Hi all,
I want to link my access database to a new Excel spreadsheet so that the data is stored in Access but Excel can then read information from a table or query and then calculations can be done based on its values.
At the moment, I've got it working but some of the fields have multiple columns as they are a lookup to another table or query.
In access, the data shows as, for example, Manufacturer Name instead of the ID of the Manufacturer name.
When viewed in Excel, it shows the ID column and not the name column, so it's not very helpful.
Is there a way to make Excel show the 2nd column of the field instead of the ID column?
Thanks,
Simon
I want to link my access database to a new Excel spreadsheet so that the data is stored in Access but Excel can then read information from a table or query and then calculations can be done based on its values.
At the moment, I've got it working but some of the fields have multiple columns as they are a lookup to another table or query.
In access, the data shows as, for example, Manufacturer Name instead of the ID of the Manufacturer name.
When viewed in Excel, it shows the ID column and not the name column, so it's not very helpful.
Is there a way to make Excel show the 2nd column of the field instead of the ID column?
Thanks,
Simon