Strategy to Import Parent/Child table data from Excel..

D

don

I'd like to set up ability to Import from Excel to update/append multiple
tables in Access 2007, as in example below (essentially to assign multiple
specialties per expert).

What might be best strategy to address, in terms of how to feed in from
Excel and VBA to process?

(in Excel, list each specialty on separate Expert row?.. or multiple columns
on a single Expert row? or carriage control within 1 column to fit multiple?

Expert table:
ExpertID(autonum), Name, Address

ExpertSpecialties table:
ID(autonum),ExpertID, SpecialtyID

Specialty table:
SpecialtyID(autonum), Specialty(text)

Thanks!
 
D

don

Thanks - any ideas how to handle an expert with multiple specialties; in
other words the best way to set up in excel so Access can most easily parse,
etc? Like, put the specialties for an expert all in 1 column...or spread
across multiple columns...or duplicate expert row for each specialty?
thanks!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Linked Child Record Losing Parent ID 2
import from excel with data validation 6
Button to import Excel into two Access tables 1
Import - Only data that has changed 1
automatically import multiple named-ranges from Excel to Access 6
Clear Data in Table, then Import from Excel SS 2
Importing from Excel by cell 2
Make one final list from four sources 1

Top