import data

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



.

Relevant Pages

  • Re: Summing duplicates
    ... this Excel file to a temp table then use that to populate inventory. ... The problem is that the Excel file contains duplicate records. ... a duplicate if Item and Shelf are the same. ...
    (microsoft.public.sqlserver)
  • Re: Summing duplicates
    ... this Excel file to a temp table then use that to populate inventory. ... The problem is that the Excel file contains duplicate records. ... a duplicate if Item and Shelf are the same. ...
    (microsoft.public.sqlserver)
  • Re: removing duplicate entries
    ... Newbie here, first time post. ... I have an Excel file of about 6000 names which has been compiled by ... simply adding two separate files, one from office and the other from ... Column A is just a list of names, I just need to delete duplicate ...
    (microsoft.public.excel.misc)
  • Re: password for end user
    ... But I've seen some posts that say that the password disappears when they've ... I can't duplicate it. ... I know you can set a password for an excel file to OPEN or MODIFY, ...
    (microsoft.public.excel.programming)
  • Determining duplicate values across multiple columns
    ... >I have two columns in my Excel file. ... >I want a two column primary key. ... >which will show if a value is a duplicate in column A. ...
    (microsoft.public.excel.misc)