SEO

#1 (**permalink**) 04-08-2008, 06:03 PM

Hello,

could someone give me an example how to connect to Sybase (ASE 12.5)
from a Visual Basic Macro/Procedure using an ODBC connection. What I
would like to do is

a.) Issue a SQL Statement
Process the results in a loop

b.) insert rows in tables

c.) Update/deletd rows in tables

I have done things like this before using ct-library, db-library, jdbc
what I'm looking for is some sample VBA Code using ODBC because I am a
newbie to VBA/Odbc programming and I googled alreay but did not find
something useful ... :-( (well, the task is to do it from Excel, I'm
struggling a little bit with MSQuery ;-). Or should I use OLE, ADO or
what would be the best choice?

Thanks for your help.

Cheers,

Dietmar

#2 (**permalink**) 04-08-2008, 06:11 PM

Dear Dietmar,

You could also make use of SQL*XL. SQL*XL hides all the intrinsic
difficulties with drivers etc and will just let you execute the query and
put the results somewhere. SQL*XL supports macro recording so you can make
your own utilities with it.

For further information see: www.oraxcel.com

I have tested SQL*XL against Sybase ASA and SQL Anywhere recently.

Gerrit-Jan Linker
Linker IT Software
www.oraxcel.com

> I have done things like this before using ct-library, db-library, jdbc
> what I'm looking for is some sample VBA Code using ODBC because I am a
> newbie to VBA/Odbc programming and I googled alreay but did not find
> something useful ... :-( (well, the task is to do it from Excel, I'm
> struggling a little bit with MSQuery ;-). Or should I use OLE, ADO or what
> would be the best choice?

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

SEO

Some Sample Visual Basic ODBC Code