Import Multiple Excel Tables-Same Format

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
 
G

Guest

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

import multiple Excel worksheet into a main Access table 1
Import multiple Excel tabs into access 4
Error while import Excel file to Access 6
Excel in imported in same sort order 2
An error occurred trying to import file 'c:\temp\import.txt'. The file was not imported. 0
Importing into existing table 5
Import Single File into Multiple Tables (Access 2003) 7
trying to import data from excel 4

Top