Updating Excel forecasts into an Access Database

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Trend Forecast Help 3
Forecasting Functions 2
forecasting 1
Forecasting a figure in Excel 1
Query for Forecasting Fuel Usage 1
Summary of shipments by month 5
Lookup by reference to months? 1
Excel: How to forecast 12 months' figures but force a 10% growth? 1

Back
Top