Want to import multiple excel files to existing Access DB

[jillca]

I have several Excel files all with extremely different data, but having a
common identifier, that I want to import into an existing Access database
that contains the identifier. These are huge files. I realize that the
field names need to be identical to those in Access. It is not possible to
combine the Excel files.

Is there any way to do this without creating separate instances of the
"identifier' in Access

A simplistic example - House A - color is green in one excel file
House A - Number of stories is in a different excel file
House A - construction type in yet a different excel file

Can I get all this information into Access in one instance of House A, where
House A exists and has info on its city?

I am running Access 2002 SP3 and Excel 2003 SP2

thanks
jill

 

[Douglas J. Steele]

If the spreadsheets are related to one another, presumably you've already
got a common identifier. Use that, rather than having Access create its own.

 

[box2003]

You may be able to import each spreadsheet into a disposable table, run a
query on that table to map the fields to your final destination, append that
to your final destination, your final table.

 

[jillca]

OK, sounds like it's doable. However, I'm an Access neophyte. How do I go
about doing this?

BTW there is some duplicate information inthe files. will that cause a
problem?

jill