How do you import .csv data files into an access table? I am looking for a step by step instructions. If somebody could help me, it would be greatly appreciated.

Part of my assignment is to import a .csv excel file into Access. But no matter what I do, I can't seem to do it. It either doesn't work, or when it works, I can't make the necessary changes, as instructed in the assignment.

4. Len exported the customer data he was maintaining in another computer system to a text file, Import the data from Customers.csv into a new table in the LuckyTire database.

 Specify Customers.csv as the source of your data.

 Select Import the source data into a new table in the current database

 Select import in a delimited format.

 Select comma delimited and click the First Row Contains Field Names checkbox.

 Select the Indexed option Yes (No Duplicates).

 Choose CustID as the primary key.

 Name the new table Customers. (Do not save import steps.)

[img]http://img84.imageshack.us/img84/6733/accessprob1.png[/img]

It won't let me make the changes in the picture. When I try to go into design view, it says that I can't make changes, to make the changes in the original file, or something like that, and then it lets me in design view. but if I make changes, it won't let me save.

Can somebody please give me a step by step process to importing the .csv excel file into access?