Importing Sales Data into Access

  • Thread starter Thread starter Frank
  • Start date Start date
F

Frank

Hi There,

I'm not sure if I'm right for this group but I'll try this anyways.

I'm like to import a daily sales report from Excell into Access and have the
informiaton updated into a table so I can do some analysis on the sales data.
Then I would like to be able to take the sales report and look up a year to
date information or check performance for the past week.

Any help would be very much appreciated!
 
Frank

Consider using a link to the Excel data, then a query (or queries) to
"parse" the data into more permanent (and well-normalized) Access tables.

You will probably find more "eyes" on your question about the reporting if
you post in the reports newsgroup.

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
Back
Top