Post reply

Issue with Loading data from Excel sheet to SQL Server Table using SSIS package

  • February 3, 2012 at 10:01 am

    #267646

    Hi,

    I have get some crazy error when i am trying to import data

    from Excel sheet to SQL Server table using SSIS Packages.

    PLease read the below error message.

    Please help me out...

    Thanks

    TITLE: System.Data

    ------------------------------

    The 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine.

    ------------------------------

    BUTTONS:

    &Retry

    Cancel

    ------------------------------

  • February 3, 2012 at 11:20 am

    #1442561

    It might be an issue of 64 vs. 32 bit (compiled using 32 bit, then transferred to a system with 32 bit).

    A quick google search using the original error message will return a number of links for further analysis... 😉

    Based on what we have so far there's very ylittle we can do except asking for more details.


    Lutz
    A pessimist is an optimist with experience.

    How to get fast answers to your question[/url]
    How to post performance related questions[/url]
    Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

  • February 3, 2012 at 11:51 am

    #1442574

    jkp2311 (2/3/2012)

    Hi,

    I have get some crazy error when i am trying to import data

    from Excel sheet to SQL Server table using SSIS Packages.

    PLease read the below error message.

    Please help me out...

    Thanks

    TITLE: System.Data

    ------------------------------

    The 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine.

    If you havn't installed the Excel data provider on the box hosting SSIS, then you'll need to do that.

    This download will install a set of components that can be used to facilitate transfer of data between 2007 Microsoft Office System files and non-Microsoft Office applications.

    http://www.microsoft.com/download/en/details.aspx?displaylang=en&id=23734

    "Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho

  • February 3, 2012 at 12:13 pm

    #1442591

    Do i need the Microsoft office 2007 in my machine...?

  • February 3, 2012 at 1:05 pm

    #1442616

    jkp2311 (2/3/2012)

    Do i need the Microsoft office 2007 in my machine...?

    On the machine running SSMS Data Import Wizzard, SSIS, etc. you would need the Excel data provider installed. SQL Server (or any other application) doesn't know what Excel is; it only knows how to interface with external data files using a provider library.

    2007 Office System Driver: Data Connectivity Components

    http://www.microsoft.com/download/en/details.aspx?displaylang=en&id=23734

    "Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho

Viewing 5 posts - 1 through 4 (of 4 total)

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