read from database and write data to file

[shaygan]

I read and type the data out from a Access database
Now I will to write this data to a file
Dim StringName
............

objCmd.CommandText = strQuery
Set objRS = objCmd.Execute
...........
//web browser output
………..
<td><%= objRS("name") %> </td>
...........
With write(objRS("name")) i cant write data to file.
how can I save this data after reading from the database
as a String (how save objRS("name") in StringName)????

StringName=

 

[FesterSXS]

As long as you havent closed the recordset then you can simply use

StringName = objRS("name")

If you want to write this value to a file then you need to use the File Scripting Object, or FSO as it is commonly known. There are lots of example of how to use the FSO within this forum and the FAQ area - do a quick search and you'll get plenty of results.

Tony
_______________________________________________________________

http://www.SpiraxSarco.com/

 

[henryhandle]

thanks