Connecting to a ODBC data source in Excel VBA - Tutorial R..

 
Post new topic   General Reply to Topic (not reply to a specific post)    Forums Home -> Query DAO RSS
Next:  Spreadsheet Query - help 2  
Author Message
Chris Strug
External


Since: Nov 13, 2003
Posts: 6



PostPosted: Wed Jun 30, 2004 9:44 pm    Post subject: Connecting to a ODBC data source in Excel VBA - Tutorial Rec
Archived from groups: microsoft>public>excel>querydao (more info?)

Hi,

I'm looking at using Excel to produce analysis from an ODBC link to a third
party application through Microsoft Query. To make it as simple to use as
possible I'd like to use VBA as much as possible.

While I have a good knowledge of Excel, VBA and ADO/DAO, I'm completely
unfamiliar with using Excel to obtain data through an ODBC link.

Simply, can anyone point me in the right direction for any web resources /
books / articles etc that would act as a introduction.

I can already use MS query to link to the app and retrieve data, however
there are things like programmatically defining query parameters and so on
that I would like to be able to do.

Just for some background, I'm going to be looking at reporting from a 3rd
party application (a warehouse management system named ATMS). This app. can
have an ODBC link set up. However as there will often be more than 65000
rows of data I'm going to have to filter it before I fetch it.

I realise that this is possible with Access (and indeed would probably be
easier in some important aspects), however because any data fetched *must*
be read only and because I'm probably going to want to do some quite
advanced analysis I have decided on using Excel.

Any and all advice is gratefully received.

Kind thanks

Chris.
Back to top
Dick Kusleika
External


Since: Jun 01, 2004
Posts: 83



PostPosted: Wed Jun 30, 2004 9:44 pm    Post subject: Re: Connecting to a ODBC data source in Excel VBA - Tutorial [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

Chris

http://www.dicks-clicks.com/excel/ExternalData.htm

The first few sections will probably be stuff you already know. There are
some VBA sections that will give you an intro into the objects, properties
and methods that you'll need.

--
Dick Kusleika
MVP - Excel
Excel Blog - Daily Dose of Excel
www.dicks-blog.com

"Chris Strug" wrote in message

 > Hi,
 >
 > I'm looking at using Excel to produce analysis from an ODBC link to a
third
 > party application through Microsoft Query. To make it as simple to use as
 > possible I'd like to use VBA as much as possible.
 >
 > While I have a good knowledge of Excel, VBA and ADO/DAO, I'm completely
 > unfamiliar with using Excel to obtain data through an ODBC link.
 >
 > Simply, can anyone point me in the right direction for any web resources /
 > books / articles etc that would act as a introduction.
 >
 > I can already use MS query to link to the app and retrieve data, however
 > there are things like programmatically defining query parameters and so on
 > that I would like to be able to do.
 >
 > Just for some background, I'm going to be looking at reporting from a 3rd
 > party application (a warehouse management system named ATMS). This app.
can
 > have an ODBC link set up. However as there will often be more than 65000
 > rows of data I'm going to have to filter it before I fetch it.
 >
 > I realise that this is possible with Access (and indeed would probably be
 > easier in some important aspects), however because any data fetched *must*
 > be read only and because I'm probably going to want to do some quite
 > advanced analysis I have decided on using Excel.
 >
 > Any and all advice is gratefully received.
 >
 > Kind thanks
 >
 > Chris.
 >
 >
Back to top
Jamie Collins
External


Since: Jun 11, 2004
Posts: 52



PostPosted: Thu Jul 01, 2004 7:34 am    Post subject: Re: Connecting to a ODBC data source in Excel VBA - Tutorial [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

"Chris Strug" wrote ...

 > I'm looking at using Excel to produce analysis from an ODBC link to a third
 > party application through Microsoft Query. To make it as simple to use as
 > possible I'd like to use VBA as much as possible.
 >
 > While I have a good knowledge of Excel, VBA and ADO/DAO, I'm completely
 > unfamiliar with using Excel to obtain data through an ODBC link.

What's the incentive/imperative to use MS Query in VBA code when you could use ADO?

Jamie.

--
Back to top
Display posts from previous:   
Post new topic   General Reply to Topic (not reply to a specific post)    Forums Home -> Query DAO All times are: Eastern Time (US & Canada)
Page 1 of 1

 
You can post new topics in this forum
You can reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum

Warning: fopen(): open_basedir restriction in effect. File(/home/adsense_reject.txt) is not within the allowed path(s): (/home/helploc:/usr/lib/php:/usr/local/lib/php:/tmp) in /home/helploc/public_html/Giga/GigaFunctions.php on line 1144

Warning: fopen(/home/adsense_reject.txt): failed to open stream: Operation not permitted in /home/helploc/public_html/Giga/GigaFunctions.php on line 1144

Warning: fwrite() expects parameter 1 to be resource, boolean given in /home/helploc/public_html/Giga/GigaFunctions.php on line 1145

Warning: fclose() expects parameter 1 to be resource, boolean given in /home/helploc/public_html/Giga/GigaFunctions.php on line 1146