Page 1 of 1
Data Pump Import from Microsoft Access file
Posted: Thu 09 Jan 2014 13:08
by UR-IT
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!
Re: Data Pump Import from Microsoft Access file
Posted: Thu 09 Jan 2014 15:24
by Viktor
Re: Data Pump Import from Microsoft Access file
Posted: Thu 09 Jan 2014 16:20
by UR-IT
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 ..."
Re: Data Pump Import from Microsoft Access file
Posted: Wed 15 Jan 2014 12:32
by alexa
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.
Re: Data Pump Import from Microsoft Access file
Posted: Sat 18 Jan 2014 14:44
by UR-IT
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.
