Combining Linked Spreadsheets to one table

[wjd01]

Hello,

I'm setting up a database that I would like to capture
information from multiple spreadsheets. The spreadsheets
will contain similar fields, but will be from seperate
users. If the spreadsheets are linked to the database, is
there a way to combine (or link) all the data into one
table which will be for updating information back to the
spreadsheet users, and overall reporting? I'm using
Access 2002 and Excel 2002.

Thanks for any assistance.

wjd01

 

[Van T. Dinh]

Not AFAIK since the only way to "combine" is to use the Union Query but
Union Query is not updateable, even with Access/JET Tables.

There may be other ways using code but in general, I don't actually link
Excel spreadsheets and try to modify the data in the Excel spreadsheets in
Access. My experience when I did this (in Excel 2000 / Access 2000) is that
the spreadsheets became corrupted and cannot be open in Excel.