trying to import a excel file to the database table ( the following error occurs )

• koolme_85

  Ten Centuries

  Points: 1153

  More actions

  May 27, 2011 at 8:49 am

  #240370

  TITLE: SQL Server Import and Export Wizard

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

  The operation could not be completed.

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

  ADDITIONAL INFORMATION:

  The 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine. (System.Data)

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

  BUTTONS:

  OK

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

• steveb.

  SSC-Forever

  Points: 46733

  More actions

  May 27, 2011 at 9:18 am

  #1331060

  you need to install the Excel driver on your machine

• koolme_85

  Ten Centuries

  Points: 1153

  More actions

  May 27, 2011 at 9:26 am

  #1331067

  where can i get that ?

• steveb.

  SSC-Forever

  Points: 46733

  More actions

  May 27, 2011 at 9:32 am

  #1331074

  Microsoft should have it.

• Orlando Colamatteo

  SSC Guru

  Points: 182279

  More actions

  May 27, 2011 at 11:57 am

  #1331162

  ACE works with Access too. Here is the redist pkg you want to install:

  http://www.microsoft.com/downloads/en/details.aspx?FamilyID=c06b8369-60dd-4b64-a44b-84b371ede16d&displaylang=en

  There are no special teachers of virtue, because virtue is taught by the whole community.
  --Plato