Re: import data

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

Hi£¬Karl,

Thanks for reply.

At the moment, in this project, it is simple: one customer for each product.
It is really so simple. :-)
What I really know is that is it necessary to write any Macro or VBA code to
make the update or append query.
I am totally new to Access, and sorry for this question if it is quite
naive.

Thanks

Li Haibo
China


"KARL DEWEY" <KARLDEWEY@xxxxxxxxxxxxxxxxxxxxxxxxx> дÈëÏûÏ¢ÐÂÎÅ:5AF9ED20-53DE-46DD-A60E-4C11E4D27F08@xxxxxxxxxxxxxxxx
You can either do an update or append query based on how you will store
the
information. Your table structure as you have it will only allow you to
have one customer for each product. I would expect you to have more than
one.
What I think you need is three tables set up in one-to-many relationships.
Product and Customer tables having a primary key field in the one relation
to
the Prod_Cust table having foreign key fields matching the Product and
Customer tables.

--
KARL DEWEY
Build a little - Test a little


"Li Haibo" wrote:

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: import data
    ... Access table and use it for a source tbl in a new update query. ... Import/Link the Excel file as a table ... "Li Haibo" wrote: ... At the moment, in this project, it is simple: one customer for each product. ...
    (microsoft.public.access.tablesdbdesign)
  • Re: storing a keyvalue while displaing other values
    ... Secondary table ORDER has fileds ID, CUSTOMER and SHIP_DATE ... Use a script to create the Order. ... record and use the CustomerID to set the relationship key field in the ... new Order record with the Customer ID automatically filled in by way of ...
    (comp.databases.filemaker)
  • Re: reasons to link tables
    ... Others here are far more skilled than I at the technical details ... Can each customer be associated with several orders? ... key field in the orders table. ... Employee table and the PK from the Meetings table. ...
    (microsoft.public.access.tablesdbdesign)
  • RE: Sequential Records
    ... [Activity Outcome ] ... customer may have multiple incidents. ... Create the relationship between the primary key field of the 'one' table to ...
    (microsoft.public.access.queries)
  • RE: Sequential Records
    ... customer may have multiple incidents. ... Create the relationship between the primary key field of the 'one' table to ... Each row consists of amongst other things, a unique ID, a customer ...
    (microsoft.public.access.queries)