Importing an excel spreadsheet

[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

 

[Nikos Yannacopoulos]

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