schema.ini file

[Guest]

Hi
Am trying to import a fixed width text file using
DoCmd.TransferText
VBA Help says "you must either specify an argument or use a schema.ini
file". Can someone advise further how to proceed?

 

[John Nurick]

To import a fixed width file you have to specify the names and widths of the
fields. For TransferText, you can do this with either an import
specification or a schema.ini file.

For the former, start importing the file manually, and click the Advanced
button in the wizard. This lets you save the specification; you can then
pass its name to TransferText.

For schema.ini, see the help topic "Initializing the Text Data Source
Driver" and/or search the Microsoft Knowledgebase. If you already have an
Access table that matches the fixed width text file, there's a KB article on
creating a schema.ini from an existing table.

 

[Guest]

The DoCmd line still falls over even after citing a successful Specification.
Am trying the schema.ini route. Thank you.