This should be so straight forward. I'm trying to use vba to export an access query to text 'with formatting and layout.' If I do this manually (External Data ribbon > Text Export), it only allows a certain number of rows. I can create an export spec but since there are so many different layouts I need, I would have to create a multitude of them. I'm really looking for something which mirrors a generic 'with formatting and layout' export. Looks like this:
--------------------------------------------------------------------------------------
| GB_ENT_SKEY | AUD_INSRT_ID | AUD_INSRT_TMSTP | AUD_UPDT_ID |
--------------------------------------------------------------------------------------
| 16389278 | HIXRC_ETL | 7/24/2014 4:02:44 | |
--------------------------------------------------------------------------------------
| 16389318 | HIXRC_ETL | 7/24/2014 4:02:44 | |
--------------------------------------------------------------------------------------
Is there something simple without acExportFixed? . . . without Export Spec?
DoCmd.TransferText acExportFixed, "Export Spec", "qSel_xxxx", "yyyyy.txt", False, ""
ASKER
That said, I did test this approach which will work just fine.
DoCmd.TransferText acExportDelim, , "qSel_xxxx", "yyyyy.txt", False, ""
Should we close this chapter and I'll thank you profusely? Or are there other ideas?