import data

[Li Haibo]

Hi, everybody:

I am now using Access 2007, and I have one table and its fields as
followings:
Product_Num (Text, no duplicate)
Customer_Num (Text)

I finished filling the data in the Product_Num filed, and there are about
500 records.
Now, the filed Customer_Num is empty at the moment.

One of my colleague has a MS Excel file which store all the Product_Num and
Customer_Num data inside.

Is there any way that I don't have to type the Customer_Num one by one
manually, but just import the data from Excel into the table without
destroying the original data I already entered?

Thanks for your help.

Regards

Li Haibo
China

 

[Stefan Hoffmann]

hi Li,

Is there any way that I don't have to type the Customer_Num one by one
manually, but just import the data from Excel into the table without
destroying the original data I already entered?

Import the Excel file or create a linked table. Use an update query with it.


mfG
--> stefan <--