ADP Import Tab Delimited File

[Guest]

Hello

I am unable to find a way to import a tab delimited text file to my .adp
project.
For some reason there is no import spec capibility in .adp projects which
makes no sence to me.
I also lookad the TransferText command but I cant find a way to specify that
it is a tab delimited file.

So if anyone can help me import my tab delimited file to a table, it would
be much appreciated.

 

[John Nurick]

Hi,

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.

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

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