Thread: Exceldata to another Excel sheet/Access database

Hi,

Encountered a problem today where maybe you guys can advise what to do. Problem goes like this:

I have an Excel sheet packed with projects (every project has a row).
Now I also need another excel file/database where all the projects are listed + some extra columns with descriptions.

The second Excel file should be updated automatically (on open/update) when I change something in the first file but ofcourse the descriptions should still match the projects and should not be changed.

I already tried making an Excel file and using the 'get external data' but then I encountered some problems with the description rows that did not match the projects anymore. That's why I thought of putting the projects in a database instead of creating a second Excel file. But I don't really know how to do this.

Thanks in advance for your help/advise.

Tim

I managed to get the rows I want in a table in Access, via 'Get external data -> Link tables'. however, I can't edit the table (add columns)/ Any advise on how to do this? (if this needs to be moved to Access forums, please do.)