[dunk_6]

hi all,

I have records in table1 and i want to copy them into text files. Can it to be done? I have example in c# codes, but it using streamWriter. If in FileSystemObject what methods should we use? I have solution in c# code, but it using streamWriter. I wanna code using VBScript WSH, and my database is MSSQL 2005 Server.

Any solution, references, or guide are very thankful..thanks

using (StreamWriter tw = File.AppendText("c:\\INMS.txt"))
				{
					using (SqlDataReader reader = cmd.ExecuteReader())
					{
						tw.WriteLine("id, ip address, message, datetime");
						while (reader.Read())
						{
							tw.Write(reader["id"].ToString());
							tw.Write(", " + reader["ip"].ToString());
							tw.Write(", " + reader["msg"].ToString());
							tw.WriteLine(", " + reader["date"].ToString());
						}
						tw.WriteLine("Report Generate at : " + DateTime.Now);
						tw.WriteLine("---------------------------------");
						tw.Close();
						reader.Close();
					}					
				}

This post has been edited by dunk_6: 10 September 2009 - 01:58 AM

[dunk_6]

Hi all..

I already found the solution. I need to put ADODB objects and the FileSystemObject from the Scripting library.

thank you.

p/s: do i need to close this topic? How ?