Excel -> Access -> Excel
 

Hi,

I'm working on an Access 2000 database where I will have a spreadsheet on a
network drive. i need people from other groups to update the spreadsheet,
but i need that info carried into the database and then back onto the
spreadsheet. i have the access - excel part figured out (I'm using the
database query using Excel), but now I need to figure out how to go from
excel - access. Anybody have any idea how this can be done? (Is it as
simple as a link directly into the database? I tried that, but my update
query in the database won't update anything....)
Thanks,
Chris

In Access you can have an Excel sheet as a linked table (provided of
course that it has a columnar table structure like an Access table).

File / Get External Data / (Excel files) / Your file / Link

Then you can use it in Access as if it were an Access table.

Bill Manville
MVP - Microsoft Excel, Oxford, England
No email replies please - respond to newsgroup