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/odbcje
tschema_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.

--
John Nurick [Microsoft Access MVP]

Please respond in the newgroup and not by email.