transfertext & schema.ini

[Bill]

For the life of me I can't get this to work...I'm trying
to EXPORT to a text file using the transfertext method and
format the output with a schema.ini file:

DoCmd.TransferText
acExportDelim, "Export_Credit", "qryTRANSFER_TEXT", "H:\Tex
t_Files\Test3.txt"

The schema.ini file is named "Schema.ini" and the export
destintation directory and the location of the schema.ini
are the same, as per the documentation. Here it is-

[Export_Credit.txt]
Format=FixedLength
CharacterSet=ANSI
Col1=Item_Number Text Width 9
Col2=Price Long Width 8
Col3=QTY Text Width 5

I get the error message: "The text export specification
file Export_Credit does not exist, you cannot import,
export or link using the specification." I've tried the
name "Export_Credit" and "Export_Credit.txt."

Bemused...

 

[david epsom dot com dot au]

It's not your fault... it's listed as broken in A2000:

ACC2000: Error When You Try to Use Schema.ini to Import or Export with the
TransferText Method
http://support.microsoft.com/default.aspx?scid=kb;en-us;241477

The article shows you how to use CurrentDB.Execute instead.

(david)