Excel to SQL ODBC link: not working when new field added

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

myemail.an@googlemail.com - 15 Apr 2008 16:46 GMT

Hi all,

I use Excel 2007, and have some Excel files with ODBC link to tables
on a Microsoft SQL Server (2005 version).

If I change the number of records in the tables in sql and then
refresh the ODBC link, everything works fine.

However, if I add a field in SQL and then refresh in Excel, the new
field won't show up. Do you have any idea why, and how I could fix it?

Thanks!

Reply to this Message

Ross Culver - 16 Apr 2008 19:49 GMT

Assuming that your external data is linked using MS Query, you'll need to
edit the query to add any new fields added in SQL. A select statement in MS
Query such as "Select * from table" still won't add any additional fields
added to SQL after the MS Query was built.

Just edit the query to add the fields.

Ross

> Hi all,
>
[quoted text clipped - 8 lines]
>
> Thanks!

Reply to this Message