Vista - SQL by field position - How

I need to get a count on a field and I need to use the field position.
How do I do this in the SQL statement?

My code:
str_grpCnt = "SELECT Fields(" & int_Column & ") as my_Group,
Count(Fields(0)) as grp_Totals " & _
"FROM [" & str_ThisFile & "] " & _
"GROUP BY Fields(" & int_Column & ")"

I cannot use a Schema.ini. I need to use the field positon because the
incoming csv text file could have a different number of fields each
time, and I need to give the user the ability to choose which field/
column to group by. Also, the incoming field will be in various
folders.

TIA

- Daron

Daron schrieb:(1) Use test code like this

Dim oFS : Set oFS = CreateObject( "Scripting.FileSystemObject" )
Dim sFSpec : sFSpec = oFS.GetAbsolutePathName( "<YourFile>" )
Dim oTCN : Set oTCN = CreateObject( "ADODB.Connection" )
Dim sCS : sCS = Join( Array( _
"Provider=Microsoft.Jet.OLEDB.4.0" _
, "Data Source=" & oFS.GetParentFolderName( sFSpec ) _
, "Extended Properties=""text;HDR=No;""" _
), ";" )
oTCN.Open sCS
Dim sSQL : sSQL = "SELECT * FROM [" & oFS.GetFileName( sFSpec ) & "]"
Dim oRS : Set oRS = oTCN.Execute( sSQL )
Dim oFld
For Each oFld In oRS.Fields
WScript.Echo oFld.Name
Next
WScript.Echo oRS( "F1" )
oRS.Close
oTCN.Close

to verify that on your system (without schema.ini definition and with
"HDR=No") the default/automatic field names really are "F1", "F2", ...

(2) Use "SELECT F<N> ... GROUP BY F<N>" accordingly

On Aug 2, 6:22*pm, "ekkehard.horner" <ekkehard.hor...@xxxxxx> wrote:Thank you. I will try this on Monday when I get back.