• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

How to import data from mdb file to Excel.

IceFrogBG

Member
Hello everyone,
Now I have a problem when import data from .mdb file to MS Excel.
I have some mdb file is protected by password (I know this password : "vb6sp5")
And I have to take some information from these file.
My idea :
- import data from mdb file to excel
- take data which I need
- calculate
I want to make a macro to import data automatic.
But now when I import data to excel there is a error occured.
(when import by manual is OK)
Everyone can check my file and support me to solved this problem.
I'm thank you so much.
 

Attachments

Chihiro

Excel Ninja
Hmm, is the mdb made by Access97?

Try using Jet.OLEDB.4.0 and ADODB code to access record.

See link for an example.
https://chandoo.org/forum/threads/excel-vba-import-data-from-access-database.21533/#post-129878

Unfortunately I can't test, as I'm on 64 bit environment and am unable to open or connect to old .mdb file.

Another alternative is to open it using Access2010 (or 2003), and convert it to accdb format.

https://support.office.com/en-us/article/convert-a-database-to-the-accdb-file-format-098ddd31-5f84-4e89-8f44-db0cf7c11acd
 

IceFrogBG

Member
Hmm, is the mdb made by Access97?

Try using Jet.OLEDB.4.0 and ADODB code to access record.

See link for an example.
https://chandoo.org/forum/threads/excel-vba-import-data-from-access-database.21533/#post-129878

Unfortunately I can't test, as I'm on 64 bit environment and am unable to open or connect to old .mdb file.

Another alternative is to open it using Access2010 (or 2003), and convert it to accdb format.

https://support.office.com/en-us/article/convert-a-database-to-the-accdb-file-format-098ddd31-5f84-4e89-8f44-db0cf7c11acd
Hello Chihiro,
Thank you so much for your answer.
I read your link but my mdb file have a password.
if this file don't have pass I think it is easy to import.
 

Chihiro

Excel Ninja
Nope. It's not the issue with password. For me it's issue of mdb file version incompatibility. I use 64 bit Office. Which will not be able to connect to old mdb file, as Jet 4.0 provider isn't supported for 64 bit.

Your connection string is bit verbose and looks off. Try studying ADO code in the thread that I linked. Along with appropriate connection string from link below.

https://www.connectionstrings.com/microsoft-jet-ole-db-4-0/
 

Dr.Excel

New Member
Hello!
Access with password cant make any trouble and more over version of Excel or Access make no problems
try this
"
"provider=Microsoft.ACE.OLEDB.12.0;" & _
"Data Source=" & App.Path & "\Filename.mdb;" & _
"Jet OLEDB:Database Password= vb6sp5 "
 
Top