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

Import Data

Hi everybody,
I want to import data from different server.

According to my system. when we sell anything to our customer we upload all the information to webserver from our local server. This job we are doing it manually right now. but i want to upload the information automatically. when my agents sell something and they submit as sell i want to send a copy of information to my webserver automatically. Is there any trigger which can insert data into different server or schedule which can import data from different server. Please help meread BOL about trigger,if u want immediate update to ur webserver.
Or u can write procedures and schedule it,check BOL schedule job.|||I try to steer clear of triggers which operate outside the scope of the database. Consider using the trigger to populate a staging table of changes, and then running a scheduled job to load those changes to your destination database. This setup is more tolerant of system disruptions.