Data Pump Import from Microsoft Access file

Discussion of open issues, suggestions and bugs regarding database management and administration tools for MySQL
Post Reply
UR-IT
Posts: 7
Joined: Mon 30 Dec 2013 14:57

Data Pump Import from Microsoft Access file

Post by UR-IT » Thu 09 Jan 2014 13:08

Hi,
i've trouble importing Access2010 Data installed on Win7 64bit. It can't connect because
ole db-provider (jet.OLEDB 4.0 Microsoft.ACE.OLEDB 12.0) can't be found.

Any idea will be fine!

Viktor
Devart Team
Posts: 68
Joined: Thu 06 May 2010 08:12

Re: Data Pump Import from Microsoft Access file

Post by Viktor » Thu 09 Jan 2014 15:24


UR-IT
Posts: 7
Joined: Mon 30 Dec 2013 14:57

Re: Data Pump Import from Microsoft Access file

Post by UR-IT » Thu 09 Jan 2014 16:20

I've this installed - 32bit as well as 64bit.

If i do somewhat in my c# code

Provider=Microsoft.Jet.OLEDB.4.0; Data Source=C:\\Programme\\..\\MyAccess.mdb"

it worked.

Did i do something wrong like "not registered the latest ..."

alexa

Re: Data Pump Import from Microsoft Access file

Post by alexa » Wed 15 Jan 2014 12:32

dbForge Studio for MySQL is installed as anycpu, which means that, if the operating system is a 64-bit one, the dbForge application will start as a 64-bit application. Therefore, to import Access2010 Data with dbForge, you need to install a 64-bit ole db-provider that you can download at http://www.microsoft.com/en-us/download ... x?id=13255

Please make sure you download the file AccessDatabaseEngine_x64.exe

Please let us know if you succeed on this.

UR-IT
Posts: 7
Joined: Mon 30 Dec 2013 14:57

Re: Data Pump Import from Microsoft Access file

Post by UR-IT » Sat 18 Jan 2014 14:44

i had done this - googlesBing research shows a lot of similar questions. Try to deinstall and reenstall 32/64 Bit
drivers didn't work (using the 64wow Version etc). The interesting thing is it works in my VS2012 c# 32/64 bit compilations. At the end i coming up using the local xp because i need the upload just one time and the say
good bye Access. :mrgreen:

Post Reply