Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

I've got several users that need to import / export ACCDB Access files into out of SQL Server.

Unfortunately, I have been unable to get 'Microsoft Office 12.0 Access Database Engine' to show up as a data source despite installing / uninstalling seemingly every different bit version of the driver:

We are running SQL Server 64 bit Enterprise 2012 on Server 2008 R2 64 bit. No Office is installed on the server itself.

I'm curious to see what is the proper configuration, because nothing is working for me! Wondering if I'm missing another component.

Used the following drivers to no avail:

http://www.microsoft.com/download/en/details.aspx?displaylang=en&WT.mc_id=soc-n-%5BTR%5D-loc-%5BServices%5D-%5Bfarukc%5D&id=13255

Also have tried this:

http://www.microsoft.com/en-us/download/details.aspx?id=23734

share|improve this question
3  
From the first link, which version did you install? IIRC, SSMS is 32bit so you'd need to install that one for this to work. Also, are you doing this on your server or on a workstation? –  swasheck Jan 25 '13 at 23:22
    
I've tried both. This is going on a server. –  billobo Jan 27 '13 at 21:47

1 Answer 1

the driver needs to be installed on whatever server ur on when u connect. So if your on you laptop and using managment studio to connect to sql server then the driver needs to be on you laptop

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.