Import data from excel 2007 to sql server 2005

• ekonagu

  SSChasing Mays

  Points: 657

  More actions

  August 3, 2009 at 11:20 pm

  #212918

  hello guys

  i am trying to import data from excel 2007 to sql server 2005 as i have selected the provider microsoft office 12.0 access .... in import export wizard.but when i am testing that connection the following error comes

  test connection failed because of an error in initializing provider.cannot start ur aplication.the workgroup information file is missing or opened exclusivly by another user

  wht is this error means

  i googlesd but didnt get any proper one

  pls help

• Hugo-371549

  Old Hand

  Points: 396

  More actions

  August 7, 2009 at 4:04 pm

  #1036325

  Are you tried Integration Services Project, using a SSiS package ?

  Is very easy create and reusable.