Sammenkædning med Excel

In Access you can make alink to an Excel file and use it as a table. The changes you make in Excel are visible in Access.

Use File+Get External Date+Link Tables menu and choose xls from the "Files Of Type" list

Det er jeg helt klar over, problemet ligger i at dataene ikke ligger i Excel, men i Access, det skal så bare være muligt at manipulere dem via Excel.

The solution really depends on your requirements which I dont know.
There are a number of ways you could do this, but if you need to be able to change the data in Excel AND Access then you will either have to do in in code, or keep the data in Excel and link it into Access. If you do it in code then you would need code in Excel and also Access.

It is possible to automate Excel from Access too.

http://www.mvps.org/access/modules/mdl0006.htm
http://www.mvps.org/access/modules/mdl0035.htm

status?

status!!

Har ikke lige haft tid til at kigge nærmere på det pga. dødsfald i familien... men vender tilbage asap.

very sorry to hear

how things going now?

I've only had a little time to work on it but it seems like it could be working :)

hope so :o)

and thanks