Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
uberman
Posting Yak Master
159 Posts |
 Posted - 2003-02-12 : 10:26:23
|
| I am populating an excel spreadsheet from SQL Server, which gets sent out as a report.I have a blank master .xls with the required column headings and range specified, this is copied with a new name and then registered as a linked server.I can then get data into the spreadsheet fine, but there is a slight formating issue.All the data seems to go in as text, even the numeric data. Excel is reporting (via the green triangle in the top left corner of each cell) that all the numbers are "Number stored as text" and giving me the option to corrent.I have tried all sorts of things with master .xls such as setting row formating and the the like but nothing seems to work...Has anyone else found this and has any one got a suggestion as to how to get the data into excel with out the spreadsheet complaining? |
|
|
|
|
|
Excel as linked server and format