Importing File into Table

[IceGirlAnne]

Hello All--

I created a table to import a delimited text file and did the whole line of VB code (DoCmd.TransferText acImportDelim etc...) correctly I believe, however, after I load the file into the table, I look at the table and it only contains the first field of each row. For example, in my file, I want to transfer for example: FirstName, LastName, and Age; but only the FirstName is getting transferred into the table while the other fields remain blank.

I'm pretty new at all of this, so I guess I'm missing something and I just don't know what that could be. I appreciate all of your help.

Thanks!

 

[IceGirlAnne]

Don't worry about it! I got it to work. My number fields in the table were set as long intergers and they should have just been integers. Thanks anyway!!