Data Imports

  • Thread starter Thread starter Craig Ferrier
  • Start date Start date
C

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
 
Craig Ferrier said:
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.
Click to expand...

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
 
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
 
Back
Top