Am trying to import Excel 2003 data into SQL table for SQL Server 200开发者_运维问答8. Tried to add a linked server but have met with little success.
Say that the raw text of CSV exports and an associated timestamps are stored in a database, where one record is equivalent to one export.
I am using this: insert into bla select * FROM OPENROWSET(\'Microsoft.Jet.OLEDB.4.0\', \'Excel 8.0;HDR=YES;Database=c:\\bla.xls\',
The error: OLE DB provider \'Microsoft.ACE.OLEDB.12.0\' cannot be used for distributed开发者_开发百科 queries because the provider is configured to run in single-threaded apartment mode.
I have a xml structure similar to below one: <test> <test1>test1 开发者_如何学编程value</test1>
I have a stored procedure that imports differently formatted workbooks into a database table, does work on them then drops the table.
加载中,请稍侯......