Command Text on data connection in 2010

[Ben]

Hi,
I have the following command text set in a connection to SQL server 2008. It works fine in Excel 2003, 2007, but not in 2010. Any ideas?

If I remove the where clause the connection works and retrieves prior year data as well as this one. But with the where clause it falls down in MS Excel 2010

"CALL_LINES"."dbo"."CORP_PROV_CEASE_LINES"
where week_end_date >{ts '2011-04-01 00:00:00'}

 

[RoryA]

Falls down in what way?

 

[Ben]

It doesn't connect and bring back the data from the table.

I have solved it, I changed the command type from table to SQL and changed the command text to

select*
From
"CALL_LINES"."dbo"."CORP_PROV_CEASE_LINES"
where week_end_date >{ts '2011-04-01 00:00:00'}

 

[RoryA]

Ah, I assumed you'd just left out the SELECT bits as that shouldn't technically work at all otherwise, in any version! I guess the older ones are more forgiving.