PLS Help. docmd.TransferText works but not correctly

[bnath001]

I am using Access 2000 (tried in access97 also).
I have a file with .CLI extention and it is TAB delimted.
That file has around 5 columns and when I use, DoCmd.TransferText acImportDelim, , "tbl_Hello", sFileName,
it imports all the 5 columns from .CLI file into only 1 column of "tbl_Hello" table. I have 5 columns in the table definition of "tbl_Hello" table.
I was thinking that it would import first column of .CLI file into first column of the tbl_Hello table and second column into...so on..

Can anyone suggest why it behaves like this?

Thank you
nath

 

[3587]

You will need to build an import query specification and add the name of that specifictation to your code. Example DoCmd.TransferText [transfertype][, specificationname], tablename, filename[, hasfieldnames][, HTMLtablename]. To build the specification click the Advanced button of the import dialog.

Good Luck,

 

[nath]

thanks it works

regards