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]
