Open database with Excel

Plateforme Level Extreme

Abonnement

Profil corporatif

Produits & Services

Support

Légal

English

Open database with Excel

Message

05/01/2002 09:18:07

03/01/2002 21:17:41

Information générale

Forum:

Visual Basic

Catégorie:

VBA

Titre:

Divers

Thread ID:

00600585

Message ID:

00601131

Vues:

>I'm looking for some VBA code I can use in Excel to prompt the user for and entry, then use that in a filter to grab data from an ODBC source. Any idea where I can find this code?

You need to use ActiveX Data Objects (ADO) from VBA to query your database.

Take a look at this article:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/odecore/html/deconcreatingdatasourceusingactivexdataobjectslibrary.asp

msdn.microsoft.com/officedev is the place to go for VBA programmers.

Guy Barrette, MCSD
============
Blog http://weblogs.asp.net/guybarrette
Microsoft Regional Director, Montreal, Canada www.microsoft.com/rd
MVP, ASP.NET http://mvp.support.microsoft.com/
President, Montreal Visual Studio User Group www.guvsm.net
INETA Regional Rep for Quebec www.ineta.org
UniversalThread Magazine Columnist (.NET Books Review Column) www.utmag.com
Tech Chair French Track, DevTeach 2004 & 2005 www.devteach.com
Business Architect, Microsoft Team - Nurun Inc www.nurun.com
XBox Live Gamer Tag: Slomo QC CA