Linking an Excel page to a database
Posted on 2011-09-07
How do I link a sheet in the workbook to a database, so that a few columns of data are taken from the DB?
Then, when the user has chosen to work offline, the old data will still be there and referencable by other pages in the Excel file?
I assume we could make a toggle field in the spreadsheet with two value:
which would govern whether the link becomes active or not.
How do I handle this?