Dear Srs:

As you know there are several devices that store the LOGs in Text files, for example chart recorders. Actually i have chart recorders in a TCP/IP Network i made a program in VB in order to copy the text in a SQL database automatically but the program affect the performance of my Server, Does anybody know a method for copying the text files in a SQL database automatically ?

 

If it is Microsoft SQL Server you could use bcp (bulk copy) to load the data into SQL Server. This will require some T-SQL (transact SQL) programming, but it is fairly easy. Look up information in the Books On Line (BOL).

Hope this helps,

Darren