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

  • Thread starter Thread starter don
  • Start date Start date
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!
 
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!
 
Back
Top