database

dantb · Mar 22nd, 2002, 10:00 AM

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 · Mar 22nd, 2002, 10:15 AM

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 · Mar 22nd, 2002, 10:19 AM

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 · Mar 22nd, 2002, 11:07 AM

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...;en-us;Q124218

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Mar 22nd, 2002, 10:00 AM	#1
dantb Board Regular Join Date: Mar 2002 Location: Arkansas Posts: 358	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

Mar 22nd, 2002, 10:15 AM	#2
lenze MrExcel MVP Join Date: Feb 2002 Location: Helena, MT Posts: 13,690	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.

Mar 22nd, 2002, 10:19 AM	#3
dantb Board Regular Join Date: Mar 2002 Location: Arkansas Posts: 358	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

Mar 22nd, 2002, 11:07 AM	#4
AJ Board Regular Join Date: Mar 2002 Location: =ActiveCell.Address Posts: 478	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...;en-us;Q124218