sql : put object obtained from readcdvrecordset into spread sheet

1 Star2 Stars3 Stars4 Stars5 Stars (No Ratings Yet)
Loading...
473 views
0

i have purchased time saver kit and it is very useful.
if you can provide some more example it will be great
Sub doit()
Dim fileName As String
Dim Rn As Range
Dim StrSql As String
Dim c As New Collection
c.Add “*.csv”, “1”

fileName = SelectSingleFileDialog(“Select CSV File”)

ReadCSVRecordSet fileName

‘ Set Rn = ReadCSVRecordSet(fileName, True)
‘ Sheets(“Sheet1”).Select
‘ Rn.Copy Range(“A1”)
End Sub
i am using above code to read record set
answer is given as object , but do not know how to put record on excel sheet

thanking you in advance

prakash b bajaj

Simply the best place to learn Excel VBA