We have a lot of users that use pivot tables in their Excel-sheets.
Those are connected by a datasource to a SQL Server database.
Sometimes the tables in the database changes. Columns may change name or they where removed. If this is done this kind of error occurs:
[Microsoft]ODBC SQL Server Driver][SQL Server]Invalid column name 'FromTlZone'.
So what is the simplest was to fix this kind of errors in the Excel-file ?
Regards
Roland Bengtsson
Attracs Team
The connection between Excel and a database is basically just a query being run against the database. Since there is no real link between Excel and the back end database, here is no way for changes on the database to be cascaded into the excel spreadsheet.
Pulling data from a database using a spreadsheet is just like having a SQL statement written in a notepad and trying to execute the command. If there's a syntax error, it will fail.
Microsoft Access has more functionality when it comes to databases and may be able to cascade updates to table structures of backend databases.
I '<3' reputation. If I helped, click the scales. This will be helping an internal departmental competition with co-workers.
Reputation can be granted through the Scales Icon (for classic layout), or the little Star on the bottom of the post next to the blogging function for the new forum layout.
If you're not busy, and really feel down on life, read my excel blog which may or may not have contents.
Strange that MS Access can do this but not SQL Server. Is it really not possible to read metadata from SQL DB and update the pivot-table somehow ?
Regards Roland
Originally Posted by Miraun
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks