Access / Windows 2003 Export Specification Problem

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Kevin PD - 25 Jul 2005 17:16 GMT

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

Reply to this Message

david epsom dot com dot au - 26 Jul 2005 06:26 GMT

>DoCmd.TransferText acExportDelim, Kev_3,

DoCmd.TransferText acExportDelim, "Kev_3",

(david)

> Hello,
>
[quoted text clipped - 21 lines]
>
> KevinPD

Reply to this Message

Kevin PD - 26 Jul 2005 10:26 GMT

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

> >DoCmd.TransferText acExportDelim, Kev_3,
>
[quoted text clipped - 27 lines]
> >
> > KevinPD

Reply to this Message

Kevin PD - 26 Jul 2005 14:05 GMT

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 !

> Tried this, is saying data does not match Schema.ini format. Off to check
> this out now . Will let you know what I find.
[quoted text clipped - 34 lines]
> > >
> > > KevinPD

Reply to this Message