how will you generate a csv file after entering data through forms into access db.?
ponnu
0
Light Poster
Recommended Answers
Jump to PostIf I read this correctly, you have variables saved from some forms, you now need to add these values to an excel file, right?
Jump to Postjust 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.
All 5 Replies
ponnu
0
Light Poster
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
ponnu
0
Light Poster
front end is vb6 and backend is ms access.I am new to vb programming.Thanks in advance
AndreRet
526
Senior Poster
If I read this correctly, you have variables saved from some forms, you now need to add these values to an excel file, right?
jhai_salvador
48
Junior Poster
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.
ponnu
0
Light Poster
the variables are entered through forms in vb and it is to be entered in to csv file
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.