Can Microsoft Access link to system?

[EileenJohn]

Hi, I'm new in microsoft access and I'm trying to make attendance report graph using access and excel. In order to get the data, i need to download the transaction report from time management system (.crv)and update the excel file that i've link to access.
Is it possible for me to directly link the system to access and automatically update the graph in excel? So i don't have to download the data and paste it to excel everyday.

 

[Ranman256]

No. Access can auto read live excel, But excel does not live read access.

You must update the link, or requery the access link to get the latest data.

 

[CJ_London]

with regards the other part of your question

Is it possible for me to directly link the system

yes, providing your time management system provides an ODBC driver (you will need to contact the supplier or look at their website for a suitable download). Typically it will only have read only rights. In which case you should be able to link excel to your time management system and refresh the link as required.

the .crv file extension is normally associated with the CorelDraw suite of applications, but that is graphics, not time management

 

[Galaxiom]

Is it possible for me to directly link the system to access and automatically update the graph in excel? So i don't have to download the data and paste it to excel everyday.

Yes. Excel > Data ribbon > Get External Data. The connection can be configured to refresh the data on opening or on a timer while it is open.

 

[EileenJohn]

with regards the other part of your question
yes, providing your time management system provides an ODBC driver (you will need to contact the supplier or look at their website for a suitable download). Typically it will only have read only rights. In which case you should be able to link excel to your time management system and refresh the link as required.

the .crv file extension is normally associated with the CorelDraw suite of applications, but that is graphics, not time management

Hi, so first things first i need install ODBC driver on the computer.
Then... i need to choose between User DSN, System DSN, or File DSN (what is all that things)?

Sorry, I never done this before. Can you assist me step by step or give me a link for tutorial?

Btw, I'm using MicroEngine Integrated System(xPortal3000 software). When i click on reporting button, it will ask to choose start date-end date then download the report.

 

[CJ_London]

Then... i need to choose between User DSN, System DSN, or File DSN (what is all that things)?

see this link

http://digital.ni.com/public.nsf/allkb/852559036FB6447380256ADF007C3964

Although I've heard of MicroEngine Integrated Systems, I've never used them, but this

When i click on reporting button, it will ask to choose start date-end date then download the report.

implies you don't need ODBC

I would ask Microengine for advice, or perhaps you can see if you can choose the format of the report when downloading - maybe as a .xls/.xlsx/.csv

 

[EileenJohn]

see this link

http://digital.ni.com/public.nsf/allkb/852559036FB6447380256ADF007C3964

Although I've heard of MicroEngine Integrated Systems, I've never used them, but this

implies you don't need ODBC


I would ask Microengine for advice, or perhaps you can see if you can choose the format of the report when downloading - maybe as a .xls/.xlsx/.csv

Hi, thanks a lot. They're using Firebird for their system.