Question:

Hi,

I am new in using Acces, I would like to use it for monitring daily statistics and showing these statisitcs as charts.

To clear things more I would like to upload same excel format with dialy updated statistics and see these statistics as charts to monitor it daily. And produce good looking reports automaticaly showing the bad performance of statistics.

Solution:

<No Points wanted>

First I will say that while this is possible, you run into issues regarding customization.
So I will strongly recommend that you simply move this system to Access, and bypass the entire Excel sheet.
You already have the Table in Access, so 90% of the work is done already.
All that is needed is for your data entry users to enter the data into the Access table instead of the Excel sheet.

Among the things that complicate this in Excel are:
1. If the name of the Excel fill will change form day to day
2. If you are uploading multiple days all at once.
3. If you are appending data to the same worksheet, or if each day will be in a separate sheet.
4. Finally, it will be difficult to do this “Automatically” because even more complex code is required to “Detect” the new data and
a. Make sure that it has not been imported already
b. Make sure no days were skipped.
…etc

So in the very basic sense this is easy, but for anything for complicated, the code gets complicated as well.

So Helen’s code was meant to be a generic blueprint for what you are asking.
If you are in need of someone to “describe in detail”, the you will have to provide us with the exact “details” of what your setup will be:

For example:
I have an Excel Workbook Named : MyExcelFile.XLS.
It is saved in a folder named: C:\MyExcelFolder\
Every day I add a new sheet for each days data, the sheet will be named as the date. Ex.:
04-24-2009
I need to import each days Excel data to a Table named: tblExcelDailyImports, everyday, by clicking a button in Access.
…etc
…keeping in mind that the code will be more complex as this would require *custom* programming, so if you are “a new user of Access” then you may want to buy a book on basic Excel VBA Coding.

But Again, if you used Access instead of Excel:
This will be ridiculously easy, and *No* code will be required at all.

JeffCoachman