ado text file

[Tammy B.]

I have a bunch of variables, and their values - I wanna save these to a text
file as through the adodb.

I found the connection string, but I don't quite get how to add the records
in this case.

Do i Start with an empty Text file , then execute a Create table SQL
statement, the way I would do to an Access table?

rs.createtable?? or what

I'm stuck on that step.

thanks.

The step i am stuck on is the step where I have a bunch of variables, and
their values.

Then I do set conn= server.createobject("adodb.connection")
set rs= server.createobject("adodb.recordset")

myvariable1 = "horse"
myvariable2 = "cow"
myvariable3= "sheep"
myvariable4= "personal lubricant"

Now howami going to take this and get to the RS.save to a blank text file?

Example please.

[Bob Barrows]

How do you want to store the values? As a recordset? If so, use the
rs.Fields.Append method to add Fields to your unopened recordset, open the
recordset, add your data, then use the rs.Save method to save the results to
a text file. See online help for details. Google can also help here. I know
I've posted an example of the above at least once.

On the other hand, if you just need to store them as comma-delimited values,
don't bother with a recordset. Use the filesystemobject to do this:
[url]http://msdn.microsoft.com/library/en-us/script56/html/sgworkingwithfiles.asp[/url]

HTH,
Bob Barrows


Tammy B. wrote:

> I have a bunch of variables, and their values - I wanna save these to
> a text file as through the adodb.
>
> I found the connection string, but I don't quite get how to add the
> records in this case.
>
> Do i Start with an empty Text file , then execute a Create table SQL
> statement, the way I would do to an Access table?
>
> rs.createtable?? or what
>
> I'm stuck on that step.
>
> thanks.
>
> The step i am stuck on is the step where I have a bunch of
> variables, and their values.
>
> Then I do set conn= server.createobject("adodb.connection")
> set rs= server.createobject("adodb.recordset")
>
> myvariable1 = "horse"
> myvariable2 = "cow"
> myvariable3= "sheep"
> myvariable4= "personal lubricant"
>
> Now howami going to take this and get to the RS.save to a blank text
> file?
>
> Example please.