Insert Data into SQL Server Database using VBScript

[Ernie FErro]

I've been using vbscript to read and parse data out of some text files. Is
there a way I can take this data and insert into a table in my SQL Server
database? Could someone point me in the direction of some code snippets if
it's possible or post something to get me started? Thanks in advance.
Ernie

[richard....@adminscripting.co.uk]

Hi,

You could try this to get you started - its a bit over the top as you
do not need a recordset to insert, update or delete data.

'create the connection string - called cn1 in this case with a DSN
called myDSN
set cn1 = wscript.createobject("ADODB.Connection")
cn1.commandtimeout=1000
cn1.open "myDSN"

'create your record set called rs1 in this case
set rs1 = wscript.createobject("ADODB.Recordset")

sql = "Insert into mytable (col1, col2) Values ('va1', 'val2')"
'write the data to the DB
rs1.open sql, cn1

To use the ADODB.Command object I think the below should work:

set cn1 = wscript.createobject("ADODB.Connection")
cn1.commandtimeout=1000
cn1.open "myDSN"
set myComm = wscript.CreateObject("ADODB.Command")
myComm.ActiveConnection = cn1
myComm.CommandText ="Insert into mytable (col1, col2) Values ('va1',
'val2')"
myComm.Execute

R

Richard Gascoigne

[Jeff Cochran]

How are you reading the data? With a SQL SELECT query, right? Use an
INSERT query to do the reverse.

Jeff

[ebferro]

Jeff:
No, I'm not using a query. The data is not csv or tab separated. I've
been reading it in line by line and programmatically getting the
information that I need. Now, I want to insert it into my table. Given
that the data is not uniform, could I use the SQL Select query? What
would the code to do something like that look like. Thanks in advance,
by the way.
Ernie

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

[ebferro]

Richard:
Thanks for the code. I'll give it a try.