Post reply

Export Excel data onto SQLServer 2005

  • May 1, 2008 at 11:46 am

    #186085

    I'm trying to export data from Excel onto SQLServer 2005 & here is the error message that I run into -

    "Heterogeneous queries and use of OLEDB providers are not supported in fiber mode."

    I tried all of these methods mentioned below -

    create table #ServerTable(ID INT, Level Char(50))

    select *

    into #ServerTable FROM OPENROWSET('Microsoft.Jet.OLEDB.4.0',

    'Excel 8.0;Database=C:\testing.xls;HDR=YES',

    'SELECT * FROM [CompLevelCount$]')

    insert into OPENROWSET('Microsoft.Jet.OLEDB.4.0',

    'Excel 8.0;Database=D:\Testing.xls;',

    'SELECT * FROM [CompLevelCount$]') select * from #ServerTable

  • May 1, 2008 at 1:08 pm

    #809786

    Is there a reason to not use the import wizard in Management Studio? Is this a one-time import, or something you'll do regularly?

    - Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
    Property of The Thread

    "Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon

  • May 1, 2008 at 2:31 pm

    #809814

    Gsquared -

    Import manager is throwing some kind of "SSIS" errors & when I took up to the infra team, they said, they need to re-install & that may take sometime.

    As I was running out of time, I thought I should try this.

  • May 1, 2008 at 2:44 pm

    #809819

    "Fiber mode" is part of lightweight pooling. It limits how SQL Server uses threads. Most likely, the server is set in lightweight pooling mode (it's a server option), and thus cannot deal with the type of imports and queries you need to run.

    That's probably also the problem with SSIS errors.

    If you can turn off lightweight pooling (it has limited use, look it up in Books Online for details on when to use it), that might solve your problem, without requiring a reinstall.

    - Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
    Property of The Thread

    "Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon

  • May 1, 2008 at 3:47 pm

    #809845

    Gsquared -

    Thanks a bunch !!!

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

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