Import Multiple Excel Tables-Same Format

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have an excel spreadsheet with 12 tabs, each a different month of the year.
Each tab is formatted identically. I am trying to import all/each of these
12 tables into a single access table.

The first import works just fine, however, when I go to import the second
tab of data, I get a pop up message stating:

An error occurred trying to import file '<my file name/path is here.xls>'.
The file was not imported.

This tells me nothing as to why it was not imported. The souce excel file
is closed and not being accessed. Any ideas what's going on here?

I could append all the table data into a single file, but as progressive
months occur, I will need to import a new, single months worth of data, and I
really cannot do that.

Ideas? Thanks!

pat
 
NEVER MIND! Figured out that the "primary key" access was adding was
preventing me from adding the additional rows (assuming the importing table
format no longer matched the table I was importing to!).

Anyway...thanks for reading!

pat
 
Back
Top