Source File Vs Access Table

[rana1978]

Hello.......

I have a database of which the main Table is a linked table of an Excel Sheet. I intend to edit or insert new data in the linked table of Access using a Form which will automatically update the date of excel sheet (source file).

How can I do it?

Can any one help me????

Rana

 

[DCrake]

If you have an Excel spreadsheet that is linked to Access it becomes a one way link. It becomes read only in Access you cannot update the spreadsheet via Access.

David

 

[Atomic Shrimp]

You can't do it by creating a linked table based on the sheet - Access just won't let you append records to a linked spreadsheet.

Are you wanting to let people maintain the table (i.e. add records) through Excel as well as Access? If so, it's going to get tricky - you'll need to deal with the possibility that two different people might be trying to add different records at the same time, by different methods, or just that someone might have the Excel file open when Access is trying to do something with it.

If, on the other hand, you want the table to be maintained exclusively by Access, but just have the contents available in Excel format, then probably the best way to do it is to export a fresh copy of the spreadsheet when it changes (probably not on every individual field change, but maybe on exit from a form, or when the user clicks a button)