access form for excel

[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?

 

[Guest]

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.

 

[ibnekhalid via AccessMonster.com]

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