Problem using transfertext with a schema file

A

alasbalas

I have the following two files:

alumnos.txt is:
ABELLAN GONZALEZ MARTA CRISTINA
ABIA CASTRILLO M TERESA
ABOY CEBRIAN IRENE
ABRIL MEDINA ELENA
AGUADO CARRANZA JOSE MANUEL
GARRIDO RODRIGUEZ MARIA
GONZALEZ ORTEGA ALBERTO
SANTIAGO MARTIÑO JOSE ANTONIO
SANTO DOMINGO MAYORAL PABLO
SANTOS LUACES ALFONSO MANUEL


Schema.ini is:
[alumnos.txt]
ColNameHeader=False
Format=Fixed Length
CharacterSet=ANSI
Col1=FirstName Text Width 22
Col2=Last Name Text Width 22
Col3=Name Text

and my code is:
DoCmd.TransferText acImport, "", "nueva", "C:\code\alumnos.txt"

and the result is a table called nueva but it has only 1 col called F1 when
it would have 3 cols, isn´t it?

What´s the matter? Somebody can help me?
I need use schema.ini, not a specification.

Thanks a lot in advance
 
Top