Data Imports

[Craig Ferrier]

Is there any way of import data from a single spreadsheet that needs to be
split into 3 separate tables.

or

If it can be imported into a query that includes the 3 data tables.

Thanks

Craig

 

[Arvin Meyer]

Is there any way of import data from a single spreadsheet that needs to be
split into 3 separate tables.

or

If it can be imported into a query that includes the 3 data tables.

How about importing it into a single table, then using 3 separate queries to
split up the data into 3 separate tables.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access

 

[Craig Ferrier]

This does not work as each of the items are linked.

I have 3 tables Donors, Donations, Designee

A donor makes a donation in honor of someone.

I have a Donor ID, Gift ID and Designee ID

Donations are made online into a single table - no ID numbers issued

Can that single table be imported into Access split into 3 tables or into a
query with the 3 tables combined.

Craig