Can Excel be the front end for Access and vice versa

  • Thread starter Thread starter K E Senthil Kumar
  • Start date Start date
K

K E Senthil Kumar

Hi,

I am trying to develop a Expense form. I am trying to develop the same in
access, but since there are different type of calculations to be done, i am
finding it difficult to design the same in Access. however, i am thinking of
using Excel as a front end, since calculations can be done easily in excel.
Is this possible.

The general gudeline would be: Create a template in Excel, the fields should
come from the Access table, and then the calculated fields should go to the
database and a report created from access or excel. is this possible

Any body could point me in the right direction.

thanks
kesk
 
K E Senthil Kumar said:
Hi,

I am trying to develop a Expense form. I am trying to develop the same in
access, but since there are different type of calculations to be done, i am
finding it difficult to design the same in Access. however, i am thinking of
using Excel as a front end, since calculations can be done easily in excel.
Is this possible.

The general gudeline would be: Create a template in Excel, the fields should
come from the Access table, and then the calculated fields should go to the
database and a report created from access or excel. is this possible

Any body could point me in the right direction.

thanks
kesk
Click to expand...

Access use a different kind of calculation, but you can do anything you
need.
If you need Access like BE you can Merge Excel Datasheet Fields to Access
Table.

Read about it on Help.

Alessandro(IT)
 
Excel can also use either ADO or DAO, just like Access.
Just set a reference to ADO, and away you go.

If you need help with the connection string property, open
up your database and in the debug window (CTRL-G), type:
?CurrentProject.Connection


Use that string in Excel, and the rest is pretty much the
same.



Chris
 
Back
Top