Urgent - table export

[MattBegg]

Help

I am trying to export a table as a delimited text file, but the file is empty.

I am using the following code:

DoCmd.TransferText acExportDelim, , "F_Phys_Exam", "D:\" & newdir & "\" & UserName & "_F_Phys_Exam_csv.txt"

Please help

Matt
Regards

Matt

matt@begg-uk.co.uk

 

[MattBegg]

Ok sorted it

but the first field is in inverted commas and the rest of the fields are comma separated.

I do not want the inverted commas

Any suggestions ??

Matt Regards

Matt

matt@begg-uk.co.uk

 

[MissyEd]

Hi Matt,

Your syntax looks OK, so the next step as far as I can see is to check what is in your variables. Could you try this:

Debug.print "F_Phys_Exam", "D:\" & newdir & "\" & UserName & "_F_Phys_Exam_csv.txt"

and see if it produces the directory & filename you were hoping for ?

Let me know if this helps Missy Ed
Looking to exchange ideas and tips on VB and MS Access development as well as office 97 development. Drop me a line: msedbbw@hotmail.com