Using Script to query Access
-
A quick simple question: I want to query access using only script (I'm using VB), then loop through the data? I know this is easy, and I think it's similar to how I do things in ASP, but does anyone know where a simple tutorial is? Also one for script querying SQL would be great. Thanks
-
A quick simple question: I want to query access using only script (I'm using VB), then loop through the data? I know this is easy, and I think it's similar to how I do things in ASP, but does anyone know where a simple tutorial is? Also one for script querying SQL would be great. Thanks
a little VBScript should do the trick.....
dim oConn as ADODB.Connection oConn.Open(ConnectionStringHere) dim oRS as new ADODB.Recordset oRS.Open ("SELECT * FROM SomeTable", oConn) while oRS.EOF = false and oRS.BOF=false call MyProcessingFuntion() wendapologies if it's not quite bang on - been a while since I've done ANY VBS :$ "Now I guess I'll sit back and watch people misinterpret what I just said......" Christian Graus At The Soapbox