access import from excel

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