Hi,
I'm creating a macro to output to txt but I get lots of dashes and pipes rather than a comma delimited file, can anyone help please?
Michael
Hi,
I'm creating a macro to output to txt but I get lots of dashes and pipes rather than a comma delimited file, can anyone help please?
Michael
Are you trying to do a transfertxt on a query or export a table or...?
Sorry, I'm using a macro with the outputTo action.
Please list the macro exactly as you are trying to use it, ie the macro name and the parameters.
The macro is called: 07 Create Verified correct txt file
Its and outputTo action
Here are the parameters
object type = Table
object name = RE Constit and Addr Fields Addr Ver Correct
output format = Text Files(*.txt)
outputfile = C:\QAS\QAS October 2011\Adress Cleaning DB\to Import onto RE\verified correct.txt
autostart = No
Template file = (is blank)
Encoding = (is blank)
Thanks
Google the Access TransferTxt method
That works a treat. Thanks for your help.