Software

Ask something
Discussion Locked

access import from excel

0 helpful
7 replies

by jimbo

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

Hello

I?m trying to import few thousand excel work sheet
Into existing access table
There are few common fields between them
Both are office 2000 application,
I imported one sheet for testing purposes and using join table or
Append query I was not successful with error comes as
Invalid argument however this is not way to go since would take lifetime
To finish
Any help would be appreciate

Jim

7 replies

by dklippert

It can be done, but you'll need to find a common ground.
Perhaps you'll want to import the sheets into Access as seperate tables and then use a Query to join them.
Or clean them up on the Excel side before attempting the import.

by richtee

Another aspect to check on is:

When importing --- confirm the data types of the fields imported from Excel are the same as the data types in your Access table. The import function does not always 'interpret' the data type you are using.

by boulderridge

As already stated, you will need to work out the problems with your test sheet first. Then, assuming all sheets have a common structure, you can automate the import and handling of the sheets in VBA. If you have many files or sheets perhaps use a table where each entry is a filename or sheet name to drive your automated import process. If you need more detail let me know.

This discussion is closed to new replies.