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 |
|
webalchemy
Starting Member
4 Posts |
 Posted - 2006-10-25 : 10:52:33
|
| I'm using OpenRowSet to successfully export data from a SQL Server table to Excel... however all data is coming down as text.I've tried formatting the target spreadsheet as numeric to no avail. Is there something specific I need to do to get numbers and dates to export in their native format?Thank you.Doug |
|
|
webalchemy
Starting Member
4 Posts |
Posted - 2006-10-26 : 09:11:59
|
| Madhivanan makes reference to this problem here:http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=49926but his suggestion to simply format the Excel spreadsheet ahead of time to 'number' does not seem to work. The data still comes across as text for all cells.Has anyone figured out a way to get the data properly formatted? |
 |
|
|
|
|
|
OpenRowSet: export to Excel is all text