access database query

[ken gray]

i have a query that i need to have qm hit an access query and pull the data out so i can send emails via blat (blat.net).

how can i do this?

Thanks.

[Gintaras]

I cannot help much. It is possible to use COM. Begin from this:

Code:

Copy      Help

typelib Access {4AFFC9A0-5F99-101B-AF4E-00AA003F0F07} 9.0
Access.Application a._create
a.OpenCurrentDatabase(_s.expandpath("$personal$\db1.mdb") 0 "")
a.Visible=-1
3

[ken gray]

this really works well. i was wondering if there is a way to have the output not put in all the "-" and "|". any ideas?

-------------------------------------------------------
| File Name |
-------------------------------------------------------
| 175.txt |
-------------------------------------------------------
| 503.htm |
-------------------------------------------------------


thanks.

[ken gray]

nvmd!

wow the database type is really nice!!!!!!

fyi here's how to pull a query

Code:

Copy      Help

db.QueryArr("SELECT * FROM [Query Name Here]" a)

Nice work G.!


use this now
Database /odbc