Export Query to Tab Delimited Text File VBA Code

[colonel66]

hi

I need to export the results of a query to a TAB delimited tex file

i can successfully export the query to a text file, to a specified folder, but the default option is comma delimited and i need TAB delimited.:banghead::banghead:

code:

DoCmd.TransferText acExportDelim, , "Price_Distribution_Export", FilePath, True

Google says do an export using the wizard and then to save the export. In MS Access 2013 the wizard has no advance tab. so no luck there

Further google research says i must create a Schema.ini File. This seems to be the proper way to do it. So I have created the following text file:

[PriceSpecs.txt]
ColNameHeader=True
Format=TabDelimited
Col1="Message Type Code" Text
Col2="Type Code" Text
Col3="ManCo Code" Text
Col4="Value Date" DateTime
Col5="Price", Double
Col6="Status" Text

The question what are the next steps to get the VBA code to create the export format per the Schema.ini Text File. I know that i need to insert something appropriate in between the commas, but what? And are there other steps i need to do?

Thanks in advance!!!

 

[static]

Google says do an export using the wizard and then to save the export. In MS Access 2013 the wizard has no advance tab. so no luck there

Leave 'Export data with formatting' unticked.

 

[arnelgp]

Do as name suggests You, save the spec. You must carefully choosechoose tab delimiter while exporting. At the end it will ask to save the spec and name for it. WriteWrite down the name and use it later.

 

[Pat Hartman]

ALL versions of Access have an "Advanced" button if you have chosen the proper export.

 

[colonel66]

Leave 'Export data with formatting' unticked.

thanks - that was the trick

i have got it working now

thanks for the tip