Post reply

Excel 2010 Import to SQL Server 2005 using Distributed Queries

  • November 14, 2011 at 4:25 am

    #246832

    Dear All,

    please help me,

    i have installed on my computer. There are;

    + Microsoft Windows 7 Pro (32-bit) as my Operating System

    + Microsoft Office 2010 as my Office

    + Microsoft SQL Server 2005 as my Database

    + AccessDatabaseEngine.exe for Office 2010

    The Question is: How to Import Excel 2010 Files to SQL Server 2005 using Distributed Queries

    because, when i used this query;

    SELECT * INTO TEMP_INV_KUR

    FROM OPENROWSET('Microsoft.ACE.OLEDB.12.0',

    'Excel 12.0 Xml;HDR=YES;Database=C:\INV.xlsx',

    'SELECT * FROM [TEST$]');

    the error always ;

    OLE DB provider "Microsoft.ACE.OLEDB.12.0" for linked server "(null)" returned message "Unspecified error".

    Msg 7303, Level 16, State 1, Line 1

    Cannot initialize the data source object of OLE DB provider "Microsoft.ACE.OLEDB.12.0" for linked server "(null)".

    Thank you so much

  • November 14, 2011 at 8:19 pm

    #1407605

    Dear All,

    i am sorry, i placed with wrong room

    thank's

  • November 15, 2011 at 1:47 pm

    #1408160

    While I'm not 100% certain Ibelieve this to be a communication issue between the SQL OLEDB and the OLEDB 12.0 drivers.

    You'll need a "Data Connectivity Components" update, available at http://www.microsoft.com/download/en/details.aspx?displaylang=en&id=23734

    See this article for more information - http://social.microsoft.com/Forums/is/communicationsserversqldatabase/thread/079907db-5ded-4766-ac95-3c1020fbcfcb

    Good luck

    ______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply