Morning!

I need to stash a result set on an Excel sheet. Connecting to the workbook as a linked server is cool indeed. But

1- When I place data on the sheet with an 'insert into' clause, all the data seems to go over as text. I can pre-format the column on the sheet that gets the numeric data, and I can wrap the result column in a CAST() function. But neither matters. I get text.

2- My plan was to add another column to the spreadsheet, in it add the numeric column + 0, then copy that back to the original column. But, ALTER TABLE complains about having too many predicates with the table name. I used ALTER TABLE <ServerName>...<SheetName>. This is 4 predicates, and the error message says I can use only 2 (I think it's 2).

So, how can I transer numneric data and how can I use ALTER TABLE?

Thanks in advance,
Stoney

I managed to transfer a numeric to an excel spreadsheet and still end up with a numeric by changing the Destination Tab on the transformation line. By changing the default 'TableName' from Sheet1$ to New_Table it converted the field to a numeric value.