Creating 1 Access Table from 2 Excel workbooks

[Guest]

The file I'm unzipping is large and creates 2 Excel workbooks. I need to get
all of this info into only 1 Access table. How do I do this? Thanks!

 

[Joseph Meehan]

The file I'm unzipping is large and creates 2 Excel workbooks. I need
to get all of this info into only 1 Access table. How do I do this?
Thanks!

Import both sheets and use an update query to add them together.

The above assumes there are no issues not stated in the original
question.

 

[John W. Vinson]

The file I'm unzipping is large and creates 2 Excel workbooks. I need to get
all of this info into only 1 Access table. How do I do this? Thanks!

A lot depends on the structure of the workbooks. One worksheet? Many different
worksheets? All "real data" or a lot of calculated fields? Normalized design
(unlikely!) or wide-flat? What will you be doing with the data once it's in
Access?

The short answer is... create your (ideally normalized) Access tables with the
proper datatypes and field sizes, and use File... Get External Data... Link to
link to the workbooks. Choose Excel as "files of type". Then run Append
queries to migrate the data into your Access tables.

You can just use File... Get External Data... Import, but this may cause
hassles since Access must guess (and will often guess wrong!) about the
datatypes of the Excel fields.

John W. Vinson [MVP]