| Home |
| Search |
| Today's Posts |
|
#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 |
| 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) | |||
Threaded Mode
