Re: Pulling data from AS400 to Excel by SQL in VBA




"Steinar" <Steinar@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:556BA184-464B-471F-BE2A-F736D8B778F0@xxxxxxxxxxxxxxxx
Today I use MS Query (and excel 2003), but it is too timeconsuming and
inflexible for me. I know there is severeral way of doing this, but whitch
is
the easiest?

What method of connection? ADO, DAO, ....

Where do i find a good explanation for hove to use and bulid SQL within
VBA?

Thx Steinar


The native 'interface' engine for AS400/DB2 is ODBC. Thus DAO can often be a
good first tool.

However, this question is best asked in an Excel newsgroup.

-ralph


.



Relevant Pages

  • Re: Use ADO in Access 2000?
    ... There are some things you can _only_ do with DAO. ... CodeProject returns the connection to wherever the code ... Is this why I can't find a single example> of connecting to the current Access database using ADO? ...
    (microsoft.public.access.modulesdaovba)
  • Re: Strange Problems with ODBC connection to SQL Server
    ... When accessing Jet data, use DAO. ... This way you are not exposing connection information in clear ... >accesses an SQL Server 2000 repository via ODBC data source. ...
    (microsoft.public.data.odbc)
  • Re: closing DB connections
    ... I _HAVE_ seen this crap with MDB and DAO all the fucking time ... connection objects. ... and transfer them to ADO and VB6. ... I don't have this explicit closing problem; and I claim that it is ...
    (microsoft.public.access.adp.sqlserver)
  • Re: Different response times...
    ... Don't use an OLEDB connection. ... I'm partial to DAO - various comparison tests done w/ ... DAO & ADO show that DAO is as fast as or faster than ADO. ... A trick that sometimes increases connection speed w/ .mdb files is to ...
    (microsoft.public.access.queries)
  • DAOs and Connection sharing
    ... I have been using a DAO -based design to implement my applications ... business logic classes and DAOs ... Action gets a Connection from a DataSource; ...
    (comp.lang.java.programmer)