Linking Multiple Excel Spreadsheets

[ApriLee1983]

I am trying to create one access database with information from multiple
excel spreadsheets that are already in existence. I seem to be only be able
to figure out how to link one spreadsheet to one database. Can this be done?
Can the maintenance of the data continue to be done in excel but continue to
update in access?

 

[pietlinden]

I am trying to create one access database with information from multiple
excel spreadsheets that are already in existence. I seem to be only be able
to figure out how to link one spreadsheet to one database. Can this be done?
Can the maintenance of the data continue to be done in excel but continueto
update in access?

You can link as many spreadsheets or ranges in one/many sheets to as
many databases as you want. Don't think you can update from Access.
IIRC, MS lost a lawsuit, so they removed the functionality in an
update to Office2002.

Database != Spreadsheet....

what business function are you trying to perform?

 

[ApriLee1983]

We have about 20 different reports that are maintained daily by different
supervisors within the company, whether that be through an Access Database or
an Excel Spreadsheet. I am trying to link them altogether to get bits and
pieces of information from each one of those reports into one so called
"dashboard" of information for management to review.

 

[JohnBury]

I am attempting to to the same job. I can connect to the excel sheets
without a problem. however my company 'dumps' out updated sheets on a daily
/ weekly basis - all with a time stamp in the filename, hence a different
spreadsheet name! I have no problem parsing the filenames and properties to
identify the latest file, however I cannot get my code to properly update the
TableDef connect property. It appears to be read only!

Can you help!

regards

John