re: How Can I Query a Text File and Retrieve Records That Occurred on a Specific Date?

RKD — Fri, 24 Feb 2012 16:22:41 GMT

I modified the script a little bit to fit my situation and am getting an error from JET DB engine on the "objRecordset.Open" line: "no value given for one or more required parameters". Can someone help please?

Sub queryTXT(strNodeName)

Const adOpenStatic = 3

Const adLockOptimistic = 3

Const adCmdText = &H0001

Set objConnection = CreateObject("ADODB.Connection")

Set objRecordSet = CreateObject("ADODB.Recordset")

strTargetLoc = "C:\scripts\queryTXT"

objConnection.Open "Provider=Microsoft.Jet.OLEDB.4.0;" & _

"Data Source=" & strTargetLoc & ";" & "Extended Properties=""text;HDR=YES;FMT=Delimited"""

strTargetFile = "TSMClientsStatus.csv"

strSQL = "Select * FROM " & strTargetFile & " where NODE_NAME = " & strNodeName

objRecordset.Open strSQL, objConnection, adOpenStatic, adLockOptimistic, adCmdText

Do Until objRecordset.EOF

Wscript.Echo objRecordset.Fields.Item("NODE_NAME" & " " & "TCP_ADDRESS")

Loop

End Sub

arkady.me@gmail.com

re: How Can I Query a Text File and Retrieve Records That Occurred on a Specific Date?

solrepr — Tue, 10 Nov 2009 02:06:20 GMT

At the risk of self promoting, my company makes a program that would solve that exact problem, although currently it can't be automated. Using the program File Query, you could open up any fixed or delimited file, and write a simple query against it without any boiler plate code, and templates for most queries are included. Here is how you would get that information with the program.

var query = (

from line in inputFile

where line["HIREDATE"] == "3/1/2006"

select line

);

For each line in the input file where HireDate equals "3/1/2006", it would select the entire line. If the query looks similar, it's because it uses LINQ internally for the query. For more information, check out www.agiledatasoftware.com/products.html.