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 |
|
rezakhan
Starting Member
2 Posts |
 Posted - 2007-01-14 : 07:29:46
|
| Hi Anyone I am new member and happy to be here.I am having trouble exporting the correct data from sql server to an excel spreadsheet using 'OPENROWSET'The problem is that although the data from my sql table is say :'a',1,2,3 , the excel spreadsheet sees the data as :'a','1,'2,'3 ..1,2,3 are of course numbers NOT text, its just that the driver has put a single appostraphy before the number !I know there is a bug with the ISAM driver but has anyone managed to solve this or has anyone have any alternatives ?best regardsRezaR Khan |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2007-01-14 : 15:06:31
|
| Excel has no problem dealing with those numbers as number.Try to add two of them up in a new cell...Peter LarssonHelsingborg, Sweden |
 |
|
|
graz
Chief SQLTeam Crack Dealer
4149 Posts |
Posted - 2007-01-14 : 16:50:54
|
| (Moved to the new forums)-Bill===============================================Creating tomorrow's legacy systems today.One crisis at a time. |
|
|
|
rezakhan
Starting Member
2 Posts |
Posted - 2007-01-14 : 18:13:42
|
quote:
Originally posted by Peso
Excel has no problem dealing with those numbers as number.Try to add two of them up in a new cell...Hi Peter , I tried this but no dice.In Excel , '1 + '2 = 0 !Thanks for your help !RezaPeter LarssonHelsingborg, Sweden
R Khan |
|
|
|
|
|
|
|
|
OPENROWSET to excel