Postgres Pro
Downloads
Home   >   mailing lists

Re: PostgreSQL back end to Excel ap - Mailing list pgsql-novice

From Shoaib Mir
Subject Re: PostgreSQL back end to Excel ap
Date
Msg-id bf54be870612070136mc6c34cp2fd8adc7a3b2c9b7@mail.gmail.com
Whole thread Raw
In response to Re: PostgreSQL back end to Excel ap  (Glenn Davy <glenn@tangelosoftware.net>)
List pgsql-novice
Tree view
For ADO using VBScript you can use it like this:

dim conn, rst, cmd

set conn = server.createobject("ADOdb.connection")

conn.open "Data Source=testing;location=192.168.0.2;UserID=username;password=password;"

Set cmd = Server.CreateObject("ADODB.Command")

cmd.ActiveConnection = conn

cmd.CommandText = "select empno from emp"

set rst = server.createobject("ADOdb.recordset")

Set rst= cmd.Execute

do until rst.eof

<<data processing code goes here>>

loop

rst.Close
conn.Close

Hope this helps...

Regards,
Shoaib

On 12/7/06, Glenn Davy <glenn@tangelosoftware.net> wrote:
Hi Kelly - sorry to hijack your thread, but I have to know...
when you say:
> ADO (have used this with Access)

how did you do this? If you can tell me how you did this in access with
ADO (which ive never been able to do) Im pretty sure I can adopt the
approach to excel?

thanks
Glenn

---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?

              http://www.postgresql.org/docs/faq

pgsql-novice by date:

Previous
From: Glenn Davy
Date:
Subject: Re: PostgreSQL back end to Excel ap
Next
From: jennifer llerena
Date:
Subject: Sort question ! ! !