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 |
|
rlatigano
Starting Member
1 Post |
 Posted - 2010-09-30 : 14:57:04
|
| how to export to excel, incresing column with more than 255 charand i have this:exec('insert into OPENrowset(''' + @provider + ''',''' + @ExcelString + ''',''SELECT * FROM [Sheet1$]'')select * from tbltest ')and error get he OLE DB provider "Microsoft.ACE.OLEDB.12.0" for linked server "(null)" reported an error. The provider did not give any information about the errorany solution ? |
|
|
Sachin.Nand
2937 Posts |
Posted - 2010-10-01 : 02:40:58
|
| http://social.msdn.microsoft.com/Forums/en-US/sqldataaccess/thread/bb2dc720-f8f9-4b93-b5d1-cfb4f8a8b1cbPBUH |
 |
|
|
|
|
|
Export from sqlserver 2008 to Excel