I have a .bat file that runs and echos its results to a log file. I need 

to have the results from that log to be imported into an SQL table to be 

queried against for webposting results. 



I am currently doing this with the 'importtext' command in Access, but we 

are migrating to SQL and I need to know of a way to duplicate this 

functionality via an asp page to MS SQL.



This import process needs to be executed during runtime, as this import 

function is part of a bigger process that we use to run reporting.



Any help or insight on this issue would be greatly appreciated.

Thank you

Look at this:



http://www.zdnet.com/devhead/stories/articles/0,4413,2376739,00.html





>From: "Chris Alexander" <chris01_mi@h...>

>Reply-To: "ASP Web HowTo" <asp_web_howto@p...>

>To: "ASP Web HowTo" <asp_web_howto@p...>

>Subject: [asp_web_howto] importing text file data into a MSSQL table via 

>asp

>Date: Wed, 21 Feb 2001 20:32:42

>

>I have a .bat file that runs and echos its results to a log file. I need

>to have the results from that log to be imported into an SQL table to be

>queried against for webposting results.

>

>I am currently doing this with the 'importtext' command in Access, but we

>are migrating to SQL and I need to know of a way to duplicate this

>functionality via an asp page to MS SQL.

>

>This import process needs to be executed during runtime, as this import

>function is part of a bigger process that we use to run reporting.

>

>Any help or insight on this issue would be greatly appreciated.

>Thank you

>

>

Well the best way is to write a vb app that will read the contents of your

txt file, and then insert them into your SQL container. You will have to use

the ScriptingHost. I am not sure if you can do this in ASP, but as VB and

VBscript are similar languages, it might be possible. There was a post to

this board on the 20th with the Subject CDO-CDONTS- FileSystemObject, and in

that post a guy was reading from a text file and putting the contents into

an email. With full example. I am sure you can insert the information into a

SQL can instead of an email.



Mike

----- Original Message -----

From: "Chris Alexander" <chris01_mi@h...>

To: "ASP Web HowTo" <asp_web_howto@p...>

Sent: Wednesday, February 21, 2001 8:32 PM

Subject: [asp_web_howto] importing text file data into a MSSQL table via asp





> I have a .bat file that runs and echos its results to a log file. I need

> to have the results from that log to be imported into an SQL table to be

> queried against for webposting results.

>

> I am currently doing this with the 'importtext' command in Access, but we

> are migrating to SQL and I need to know of a way to duplicate this

> functionality via an asp page to MS SQL.

>

> This import process needs to be executed during runtime, as this import

> function is part of a bigger process that we use to run reporting.

>

> Any help or insight on this issue would be greatly appreciated.

> Thank you

>

>