import HTML table into SQL table

Hi Everybody,
I need to import a table from HTML into a SQL table using VBScript. I
can figure out how to get to the correct table tag using a regular
expression, but I don't know how to import the column values into a SQL
table.
Also, how do I stop when I get to the end of the HTML table? There is
an unknown number of rows in my HTML files, but always four columns.
As always, thanks for the help.
Eric BragasUse vbscript and write the content of the html table to a csv. Then it would
be a piece of cake to bcp/import the table into sqlserver.
-oj
"Eric Bragas" <ericbragas@.yahoo.com> wrote in message
news:1126539668.829200.142170@.g43g2000cwa.googlegroups.com...
> Hi Everybody,
> I need to import a table from HTML into a SQL table using VBScript. I
> can figure out how to get to the correct table tag using a regular
> expression, but I don't know how to import the column values into a SQL
> table.
> Also, how do I stop when I get to the end of the HTML table? There is
> an unknown number of rows in my HTML files, but always four columns.
> As always, thanks for the help.
> Eric Bragas
>sql

Implicit Transations and Deleted Rows

I have a problem where records a being deleted via implicit transactions (I
can see this from the SQL log). I am not sure I understand implicit
transactions fully but no where in our database or application do we ever
delete these records. Why are they being deleted via implicit transactions?Martin,
What do you mean, you can see this from the SQL Log? What is the exact
message in the sql error log?
Can you run a profiler trace on your SQL Server to see what/who is actually
sending these commands?
Do you have replication set up on this server (there is a thing known as
compensating deletes that sometimes surprises people)?
Set up a profiler trace, and make sure to capture sp:starting/completed,
stmt starting/completed, batch starting/completed, rpc starting/completed.
Make sure to include the columns loginname, hostname, etc. Of course you
will want text data and all the regular columns. If you've never set this u
p
before and you still have questions, post a message here and we can go
through this together.
Donna
"Martin" wrote:
[vbcol=seagreen]
> I have a problem where records a being deleted via implicit transactions (
I
> can see this from the SQL log). I am not sure I understand implicit
> transactions fully but no where in our database or application do we ever
> delete these records. Why are they being deleted via implicit transactions?[/vbcol
]

Implicit Transations and Deleted Rows

I have a problem where records a being deleted via implicit transactions (I
can see this from the SQL log). I am not sure I understand implicit
transactions fully but no where in our database or application do we ever
delete these records. Why are they being deleted via implicit transactions?
Martin,
What do you mean, you can see this from the SQL Log? What is the exact
message in the sql error log?
Can you run a profiler trace on your SQL Server to see what/who is actually
sending these commands?
Do you have replication set up on this server (there is a thing known as
compensating deletes that sometimes surprises people)?
Set up a profiler trace, and make sure to capture sp:starting/completed,
stmt starting/completed, batch starting/completed, rpc starting/completed.
Make sure to include the columns loginname, hostname, etc. Of course you
will want text data and all the regular columns. If you've never set this up
before and you still have questions, post a message here and we can go
through this together.
Donna
"Martin" wrote:

> I have a problem where records a being deleted via implicit transactions (I
> can see this from the SQL log). I am not sure I understand implicit
> transactions fully but no where in our database or application do we ever
> delete these records. Why are they being deleted via implicit transactions?