import and update excel spreadsheet (1 Viewer)

eugz

Registered User.
Local time
Today, 05:06
Joined
Aug 31, 2004
Messages
128
Hi All.
Is this possible? I need import 30 Excel spreadsheets from different Excel files to one Access table and update this table.
Thanks.
 

DCrake

Remembered
Local time
Today, 10:06
Joined
Jun 8, 2005
Messages
8,632
Simple Software Solutions

In short yes,
However,

Are the spreadsheets identical in layout and content types?
Will they all be on a known worksheet?
Do they all have a known number of rows?
Do they all have column headings?
Are the headings the same name and in the same order?
what happens to the spreadsheets after they have been imported?

Ask yourself these and other questions by the time you have answered all of them you will be a lot closer to the solution

CodeMaster::cool:
 

Users who are viewing this thread

Top Bottom