Export Only Certain fields within a table

[crownedzero]

I need to create a CSV from a table I have, however, I have an extra field that contains data our vendors do not need to see. The only method I'm familiar with is

DoCmd.TransferText acExportDelim

Any thoughts on this one?

 

[SOS]

I need to create a CSV from a table I have, however, I have an extra field that contains data our vendors do not need to see. The only method I'm familiar with is

DoCmd.TransferText acExportDelim

Any thoughts on this one?

Create a QUERY which contains only the fields you want exported and then use the DoCmd.TransferText with that QUERY instead of table. You can use queries anywhere you use tables (99% of the time).

 

[crownedzero]

I thought I might have to go that route but was hoping I could spare myself an additional dozen queries if I could just export the table -one.

Supposing I want to save it with the current date?

DoCmd.TransferSpreadsheet acExportDelim, "qryName", ???

 

[crownedzero]

Figured it out