Importing a text file to access

[Navop]

K this is to keep track of my inventory on parts for rc cars.

The file started out as a pdf file converted to a text file
Now I want ot import the text file in colums.



Not sure how to do it.

The file contains parts #, description, qty and price

I've included the txt file that i'm trying to use, not even sure if i'm going
about this the right way.

I might even have to vb a script to read into an array.

This is so i don't have to type in all the info I can just read the file
minupilate it to my likeings.

In advance thanks for the help or info

[ajetrumpet]

so what is the question? import it through the wizard and see what you get.

[KathyL]

K this is to keep track of my inventory on parts for rc cars.

The file started out as a pdf file converted to a text file
Now I want ot import the text file in colums.

Not sure how to do it.

In advance thanks for the help or info

Access is a whiz at imports and data conversion.
Just use the External Data, Import feature in Access 2007. It's simple to use the wizards.