tab delimited text file to access table

[jambai]

I am trying to import tab delimited text file into a MS Access table. The below is the query I am using.

INSERT INTO table1 (PName,Age) SELECT [pname], [age] FROM [Text;DATABASE=C:\Documents and Settings\MS\My Documents;].table1.txt;"

The above query insert the records into one column like
smith 30
john 30

Let me know how to insert these records into separate column.

Thanks

 

[BigRed1212]

I'm sure there is a way to do it properly and I'm sure someone will tell you how.

In the meantime, is there a way to do some sort of poor man's method and read the tab dilimited data into Excel and then read it to Access from there?

 

[Remou]

It would be easiest to use DoCmd.TransferText with a specification.

 

[jambai]

Thank you guys for your suggestions.

Actually the problem is with the Schema.ini. The below URL helped me to fix this

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

Thanks again.
Jambai