how will you generate a csv file after entering data through forms into access db.?
ponnu 0 Light Poster
Recommended Answers
Jump to Post— AndreRet 526If 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 Post— jhai_salvador 48just 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.