Transfertext Export with Specification specifies Single quotes but is adding double

[Valavien]

Hi all,

I am exporting data from an Access 2007 table saved as a 2003 mdb.

My table has only one field and it's a text field.

I am exporting a row of 8 digit numbers and my specification adds single quotes so the number should look something like this '12345678' in my txt file.

I have run this as a macro and it works but when I use DoCmd.TransferText acExportDelim, Export_File_Sync, "tbl_combined_results", GetDBPath & "File_Sync" & ".txt" the output is "12345678"

I need ' not "

Any ideas? Have tried searching for an answer but not sure if I am using the right search words.

[June7]

I did a test of exporting a query that added apostrophes to the field value. The resulting text file was quotes and apostrophes, like: "'12345678'"

Try acExportFixed instead.

[Valavien]

Thanks for the tip, I tried that and got a specification error. I believe that's because my spec is for delimited. I then realised that I can add the apostrophes using a query and then export to text using acExportFixed