Importing from Excel large files

I

Ian Grega

Hi,
I have two excel files of 40 fields and 60,000 records each. Access does not
let me combine them by importing. Is there another way and does Access's
Pivot Table feature work on databases with more than the 65,536 records that
Excel can handle?

Appreciate it if anyone could help.

Regards,
Ian
 
V

Van T. Dinh

Try importing them as 2 separate Tables and then use Access to combine the 2
Tables (using Append Query).

Alternatively, import one Excel file. link the second Excel file to your
database as a linked Table. Then use an Append Query to append Records from
the Excel-linked Table to the imported Table. When the import has all
Records from the 2 Excel file, delete the Excel-linked Table.

Access got no limits on number of Records. Check "Specifications" in Access
Help.

Note that you problems may be something else rather than the import
function. For example, mixed columns in Excel always give problems when
they are imported into Access.
 
I

Ian Grega

Van,
Thanks for your help. I will try your suggestions and let you know how it
goes.
Regards
Ian
 
I

Ian Grega

Van

For an inexperienced Access user I got lost trying to Append Queries, but as
an experiment I managed to import two simple but large Excel files to the one
Access Table.

Interestingly Access Pivot Tables will not allow a "parent" to have more
than 65,536 records (row limit for Excel) and if you export a valid pivot
table back to Excel an error pops up as only 65,536 records are exported.
Copying and pasting is ok to get a dead pivot table.

I can import my two files to Access in separate tables but not to the one
table, when I have tidied up import errors and formats it should work.

Regards
Ian
 
Top