EXCEL AS FRONT INTERFACE FOR ACCESS

Posted by roameri PM | on Fri, 22/02/2013 - 09:59 350 7 comments | report

Using an EXCEL Spreadsheet as a frontend IF and backend IF for MS Access.

I have a journal of purchases in EXCEL with coloumns for date,qty.,price etc. I want to use this as the data entry interface to create a ACCESS DB. Then I can use the DB to get my quesries,reports datewise, etc. Later I want to get a DB to EXCEL output.

Comments

There are 7 comments. Login or register to view them.

Er, Good Luck...

WhichTyler | Fri, 22/02/2013 - 10:53

Probably don't do it ....

JC | Fri, 22/02/2013 - 11:35

Link to it

ShirleyM | Fri, 22/02/2013 - 11:53

Why?

neileg | Fri, 22/02/2013 - 12:53

EXCEL AS FRONT INTERFACE FOR ACCESS

roameri | Sat, 23/02/2013 - 04:56

neileg:

roameri | Sat, 23/02/2013 - 05:00

EXCEL AS FRONT INTERFACE FOR ACCESS

roameri | Sat, 23/02/2013 - 05:04