Remove Quotes in Tab Deliminated Export

[joel009]

I am creating an export from Access 2003 SP1 on an XP pro platform. I first append records to a table then use the DoCmd.TransferText acExportDelim to create the tab deliminated file as a .txt file then renaming it to .tsv. (I couldn't find a way to export as a .tsv from Access)This is then posted to an FTP folder.

The problem is the TransferText method includes quotes (") around the text fields and the end product is required to have no quotes. Is there a way to automate it so there are no quotes around the text fields? For testing purposes I am opening the tab deliminated file and using the find/replace to replace all the quotes with nothing, this works fine but I want to automate this for the end users and avoid this manual step if possible.

Thanks,

Joel

 

[Remou]

Try creating an export specification and using that in your TransferText statement.

 

[joel009]

Excellent!!! Do you know how to remove the time from the dates?

 

[Remou]

How about Format? You can base your export on a query.

 

[joel009]

Duh!!?!?! I've been looking at this thing too long.

Thanks Remou