database

[dantb]

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

 

[lenze]

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.

 

[dantb]

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

 

[AJ]

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.

http://support.microsoft.com/default.aspx?scid=kb;en-us;Q124218