Access / Windows 2003 Export Specification Problem

[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

 

[david epsom dot com dot au]

DoCmd.TransferText acExportDelim, Kev_3,

DoCmd.TransferText acExportDelim, "Kev_3",

(david)

 

[Guest]

Tried this, is saying data does not match Schema.ini format. Off to check
this out now . Will let you know what I find.

thanks


Kevin Pd

 

[Guest]

Forget the Schema.ini file, one field in query was renamed, so export spec
based on table was ignored and system defaults were used, or so it appears !

Unable to find any documentery surport for this .....

Yours confused !