Importing an excel spreadsheet

  • Thread starter Thread starter JD
  • Start date Start date
J

JD

Hi Everyone,

I have an excel spreadsheet that I wish to import into my
access database. The database is has a contact table in
it, and each contact can be in multiple markets and
segments.....so I need to be able to import each contact,
and then import what markets/segments the contact is in.

To do this I have another table called Segment and another
one called Market.

My question....how can I import this data from within
Access2002...any help would be appreciated

JD
 
If I understand correctly, your spreadsheet is a flat
table that contains the information you want to import to
all three tables...? If this is the case, you can do it by
means of three Append queries, one for each table imported
to. Just make sure to:
1. Use totals queries where necessary so as to import
repeating info just once (for instance, contacts are most
likely repeating, so Group by on them...)
2. Import in the right order, as defined by the
relationships between your tables, that is to say a value
in field Contact_ID should exist in the table where it is
the primary key (Contacts) before a record with this value
can be appended to a table where this field is a foreing
key (I guess Contacts first, then the rest... any
relationship between markets and segments?)

Nikos
 
Back
Top