Importing Sales Data into Access

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!
 
J

Jeff Boyce

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
 

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

Top