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

[myemail.an]

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!

 

[Ross Culver]

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