3
Contributors
5
Replies
8
Views
4 Years
Discussion Span
Last Post by ponnu
0

Open "C:\MyFile.csv" For Output As #1
Do While rs.EOF = False
Print #1, rs.Fields("NAME").Value & ", " & RsFields("AGE").Value
rs.MoveNext
Loop
Close #1

0

front end is vb6 and backend is ms access.I am new to vb programming.Thanks in advance

0

If I read this correctly, you have variables saved from some forms, you now need to add these values to an excel file, right?

0

just do what ponnu said, you can replace rs.Fields("NAME").Value & ", " & RsFields("AGE").Value with var1 & ", " & var2 etc if your using variables and not database.

0

the variables are entered through forms in vb and it is to be entered in to csv file

This question has already been answered. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.