Excel to SQL import error

Geeks With Blogs

43 Posts | 243 Comments

These postings are provided "AS IS" with no warranties, and confers no rights.

virtusa corp sharepoint virtusa.com shehan peruma

Shehan Peruma

<< Tools to improve sites performance | Home | Error occurred in deployment step 'Recycle IIS Application Pool' >>

Excel to SQL import error

Comments (1) | Share

Running the import wizard on my Windows 7 (64 bit) machine, to create a table by importing an Excel file, gave me the following error:
the 'microsoft.ace.oledb.12.0' provider is not registered on the local machine

To fix this:
Download and install the following: http://www.microsoft.com/download/en/confirmation.aspx?id=23734

Posted on Wednesday, June 6, 2012 9:16 PM Administration & Configuration , Troubleshooting | Back to top

Comments on this post: Excel to SQL import error

# re: Excel to SQL import error

And there's also another way to do it, without the hassle of 32/64bit, or any drivers/providers at all -
It's called ClipTable, and it makes import look easy!

See more here -
http://www.doccolabs.com/products_cliptable.html

Left by Adi on Jun 12, 2012 5:07 PM

Your comment:

Title:

Name:

Email: (never displayed) (will show your gravatar)

Comment: Allowed tags: blockquote, a, strong, em, p, u, strike, super, sub, code

Verification:

ASP.Net SQL Server Apple Google SharePoint Windows Visual Studio Team Foundation Server Agile Office Design Patterns Web Azure