Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Create a Comma Separated Value CSV file
- Thread starter Leonard
- Start date
FRoeCassNet
Programmer
Here's a very simple approach.
RS.MoveFirst
Open "c:\output.csv" For Output As #1
Print #1, RS.GetString(, , ",", vbCrLf)
Close #1
Once you have the recordset you can convert it to a string. If there's a lot of data, you could loop through each record and then have the GetString() method only return 1 row of data and write that out each time.
RS.MoveFirst
Open "c:\output.csv" For Output As #1
Print #1, RS.GetString(, , ",", vbCrLf)
Close #1
Once you have the recordset you can convert it to a string. If there's a lot of data, you could loop through each record and then have the GetString() method only return 1 row of data and write that out each time.
Have you searched Someone may have posted a data export project that may do what you are looking for. It might be worht a look. Thanks and Good Luck!
zemp
zemp
- Status
Similar threads
- Locked
- Question