S
slowtwitch
Is there a way of using an Excel spreadsheet as a form in
Access?
Access?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
K
Keyur
yes, open a new Access database, go to file and 'Get
External data' u can either import it or link it to excel
(linking is good when u want to keep both formats as if u
change in one format it will update the other one, but u
can only open one file format at a time i.e. either excel
file or database) just follow the prompsts then. also this
will create a table and then u can go ahead and make
forms. they will all be linked.
Go to Access help and type in 'import or link data and
objects' go the link with the same title. it has
procedures for all different kinds of formats u can link to
There is also an Excel add-in made by Microsoft for this.
go to this page.
http://www.microsoft.com/downloads/details.aspx?
FamilyID=B7F9F609-5D8A-4F53-ABCB-
3D3D22774AAF&displaylang=en
hope this helps
External data' u can either import it or link it to excel
(linking is good when u want to keep both formats as if u
change in one format it will update the other one, but u
can only open one file format at a time i.e. either excel
file or database) just follow the prompsts then. also this
will create a table and then u can go ahead and make
forms. they will all be linked.
Go to Access help and type in 'import or link data and
objects' go the link with the same title. it has
procedures for all different kinds of formats u can link to
There is also an Excel add-in made by Microsoft for this.
go to this page.
http://www.microsoft.com/downloads/details.aspx?
FamilyID=B7F9F609-5D8A-4F53-ABCB-
3D3D22774AAF&displaylang=en
hope this helps