| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Updating Excel forecasts into an Access Database
I need to take the information in an excell spreadsheet (from a sales
Forecast) back into an Access Database. The forecast is in Excel under month headings with the quantities underneath. eg Row 1: April May June July Aug Row 2: 10 20 30 40 46 (The sales quantities) Can this be done? Thanks Maree |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Updating Excel forecasts into an Access Database
The Access import function will allow you to import that Excel sheet into an
Access table (select file type as Excel). If you want a dynamic update, I think that can be done, but I don't have access to Access to check it out. "Maree Maxfield" wrote: I need to take the information in an excell spreadsheet (from a sales Forecast) back into an Access Database. The forecast is in Excel under month headings with the quantities underneath. eg Row 1: April May June July Aug Row 2: 10 20 30 40 46 (The sales quantities) Can this be done? Thanks Maree |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Code to 'lookup' value in Access database | Excel Discussion (Misc queries) | |||
| Error message in Excel after exporting Access query to Excel | Excel Discussion (Misc queries) | |||
| Access -> Excel: How to export fields > 255 characters | Excel Discussion (Misc queries) | |||
| Managing an Access Database from Excel | Excel Discussion (Misc queries) | |||
| MS Access in Excel | Excel Worksheet Functions | |||
Hybrid Mode
