Member Avatar for ponnu

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

  • 3 Contributors
  • 5 Replies
  • 162 Views
  • 21 Hours Discussion Span
  • Latest Post Latest Post by ponnu
Member Avatar for ponnu

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

Member Avatar for ponnu

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

Member Avatar for AndreRet

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

Member Avatar for jhai_salvador

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.

Member Avatar for ponnu

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.