Update access file linked to excel sheet

[manmah]

Hi There

I Have an Excel spreadsheet which is updated via a front end form and the information is sent to numerous other sheets via Macros. One of the worksheets collates all the data which I have linked to an Access file. The Access file updates constantly as the the info is added into Excel but I need help to do the following if it is possible.

I would like to open up access and type in a reference number which will pull up the record in form view. Then I would like to add information to the record. This information does not need to go back to Excel. To do this I would need to add some extra fields. Is it possible??

Thanks
Mark

 

[strive4peace]

Hi Mark,

anything is possible ... within reason

> "The Access file updates constantly as the the info is added into Excel"

how does this happen? If your Access table is a linked Excel range then you cannot change its design ... but you can create an additional table with a 1-1 relationship for additional fields. What is unique in the Excel range?