New vb user. I am trying to look up a external dbase with 9 different fields and import into my Excel spreadsheet. Is there any visual basic script or comand that will do that ? Thx Dan
You could use Vb to do this, but why not use MS Query. It's an add-in that comes with Excel(Tools Add-ins). You may also have to activate the driver for your database.
At the moment I am uning queeries. The problem is I am conecting to 7 different dbases and dont nead to use but 1 or two at a time. Was hoping to speed up the sheet. Thx Dan
I've found the xlodbc addin pretty handy as well. I use it in a daily macro that processes a bunch of Excel files and then loads them into a mysql database on a Linux box (Microsoft would be proud!)
MS Knowledgebase article is quite helpful in getting started.
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.