link 2 csv files & open as recordset

[charlotte49er]

I'm trying to write an asp page that uses Jet to open two csv files. I'm trying several variations but haven't had any luck. Has anyone been able to successfully do this?

	oConn.Open "Provider=Microsoft.Jet.OLEDB.4.0;" & _
          "Data Source=" & strPathtoTextFile & ";" & _
          "Extended Properties=""text;HDR=YES;FMT=Delimited"""
	Dim strQuery
	strQuery = "SELECT * FROM ([rvf_newformat#txt]rvf_newformat,[rvf_elevation#txt]rvf_elevation WHERE rvf_newformat.SITECODE = rvf_elevation.SITECODE)"
	oRs.Open strQuery, oConn, adOpenStatic, adLockOptimistic, adCmdText