How to enter excel 2003 data into access 2003 form?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

obloko - 29 Jul 2005 08:52 GMT

I'm using excel to enter and calculate the data in it, but every day it gets
larger and larger, what makes work with table wery difficult. so is there a
way to link excel tables to access database with possibility to enter data
through data access page into excel worksheets.

Reply to this Message

KARL DEWEY - 29 Jul 2005 17:15 GMT

Yes, but I do not see how that will save you any effort.
On the menu click FILE- Get External Date - Link Tables. Select Excel as
the file type and then select the file and link.

> I'm using excel to enter and calculate the data in it, but every day it gets
> larger and larger, what makes work with table wery difficult. so is there a
> way to link excel tables to access database with possibility to enter data
> through data access page into excel worksheets.

Reply to this Message