Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Microsoft Access Report into Excel Spreadsheet | Excel Discussion (Misc queries) | |||
How do I get an Access form in Excel to Expand the Data | Excel Discussion (Misc queries) | |||
How can I open an Access adp file from excel? | Excel Discussion (Misc queries) | |||
Linking Excel to Access. | Excel Discussion (Misc queries) | |||
Managing an Access Database from Excel | Excel Discussion (Misc queries) |