How can I import a fix lenght file using schema.ini

[dorisr]

Hi All,
I'm trying to import a fix lenght file using a schema.ini file and it does't work.... I get the error message 3625 run time error. Schema.ini does not exist.

Here is my command :
DoCmd.TransferText acImportFixed, "Schema.ini", "LEVELS", "C:\share\newfile.txt"

my schema.ini file :
[newfile.txt]
ColNameHeader = False
CharacterSet = ANSI
Format=FixedLength
Col1=LEVEL_MNEMONIC Text Width 14
Col2=LEVEL_DESC Text Width 60
Col3=LEVEL_DEPARTMENT Text Width 18
Col4=LEVEL_DEP_NAME Text Width 30

I read a few article but... doent seems to work for me.... Can anyone help me please ?

 

[DJkarl]

Have you tried the suggestion from MS?

http://support.microsoft.com/kb/241477