how will you generate a csv file after entering data through forms into access db.?

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

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

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

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.

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.