Transfertext

[Julien Konan via AccessMonster.com]

Hi,
I want to import a .txt via VBA. this text need a specification and I use an
Access Project (and I don't think it's possible to save specification in a .
adp). so I don't success with the Transfertext method. Any idea?

 

[John Nurick]

Hi Julien,

You can use a schema.ini file instead of an import specification.
schema.ini must be placed in the same folder as the file you're
importing, and must have a section headed with the exact filename.

Documentation is towards the end of the Help topic "Initializing the
Text Data Source Driver" (under Microsoft Jet SQL Reference). These
links may also be useful:

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/odbc/htm/odbcjetschema_ini_file.asp

Create a Schema.ini file based on an existing table in your database:
http://support.microsoft.com/default.aspx?scid=kb;EN-US;155512

http://support.microsoft.com/default.aspx?scid=kb;EN-US;149090
http://www.devx.com/tips/Tip/12566

Access will create a schema.ini file automatically if you export to
Microsoft Word Merge format.