access form for excel

I

ibnekhalid

i am maintaining my data in excel. can i use an "Access" form to feed data in
excel. and same way i want to generate a report in access which is based upon
the same data from excel. can anybody guide me how to do this?
 
C

caloy

ibnekhalid,
You can create an Access table linked to the excel spreadsheet. From there
you can create a form using this table which should in turn update that
table. In regard to generating a report, you can creat one using the "Report"
wizard, using the same access table. Hope this helps.
 
I

ibnekhalid via AccessMonster.com

thanks for the hint, can u tell me ow to link up both tables?
 
Top