G
Guest
Hello,
Can someone point me in the right direction re the following.
I have the following line of code
DoCmd.TransferText acExportDelim, Kev_3,
"qry_302_654f_PM02_PMS_EDi_Extraction" , "d:\Access Report
Testing\PMS_EDI_form.txt", False
It succesfully produces output, but ignores the export spec "Kev_3" which
should output the data with a | delimiter, no text delimiter and no file
headings.
If I actually 'export' the file behind the query "qry_302 ...." it does use
the export spec. I have removed from MSysIMEXSpecs all other export specs, it
now contains only "Kev_3".
This worked on a Access / Window 2000 box, but on 2003 no joy.
Any suggestions ??
KevinPD
Can someone point me in the right direction re the following.
I have the following line of code
DoCmd.TransferText acExportDelim, Kev_3,
"qry_302_654f_PM02_PMS_EDi_Extraction" , "d:\Access Report
Testing\PMS_EDI_form.txt", False
It succesfully produces output, but ignores the export spec "Kev_3" which
should output the data with a | delimiter, no text delimiter and no file
headings.
If I actually 'export' the file behind the query "qry_302 ...." it does use
the export spec. I have removed from MSysIMEXSpecs all other export specs, it
now contains only "Kev_3".
This worked on a Access / Window 2000 box, but on 2003 no joy.
Any suggestions ??
KevinPD