Import MB-files in Excel (VBA)

Emperor

Board Regular
Joined
Mar 25, 2010
Messages
225
Hi all,

Is there a way to import parts of a *.MB database file?
I've got hundrets (maybe thousands) of database files which I really need in Excel.

Somebody please can help me to find a good method?

Thanks!

Mathijs

*p.s. When I google, I can not find anything, all the hits are about files of x.x Megabyte ^^
 

Excel Facts

Do you hate GETPIVOTDATA?
Prevent GETPIVOTDATA. Select inside a PivotTable. In the Analyze tab of the ribbon, open the dropown next to Options and turn it off

Emperor

Board Regular
Joined
Mar 25, 2010
Messages
225
Wish it was so easy, they are from a building calculations program, developed by 'Kraan'

I have downloaded a 'Paradox Viewer', with this I can read the information needed, but I would like to automatically import it into Excel (beacause of the amount of files)

Maybe it needs to be imported in Acces, controled by Excel?

Mathijs.
 

Ruddles

Well-known Member
Joined
Aug 24, 2010
Messages
5,786
Can you make one available for us to 'play' with?
 

Watch MrExcel Video

Forum statistics

Threads
1,129,754
Messages
5,638,170
Members
417,011
Latest member
Amaden95

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top