Hi
I am totaly new to MS Access.
I have one worksheet in excel in which I have data of company's inventory.
I want to know can I transfer data from a form made in MS Access to the Excel worksheet?
Can I use access form to fetch or update data in excel worksheet?
Can I use MS Access as frontend Or I have to use another frontend like VB?
Have a look at how you LINK tables to an Access database.
(File...Get External Data....Link Tables...in the files of type dropdown select Microsoft Excel)
You will be prompted for the location of the excel file and which sheet you wish to attach as a table.
This may or may not do as you require overall it depends how you have your data organised in the spreadsheet. Remember we are talking tables here... many people treat excel as though it were a word processor with some layouts I've seen.
Another method is via 'Automation' but that involves using VBA code which I won't go into if you are totally new. It may be that simple attaching might suffice for you
Regards
Jim :)