Updating SQL tables

[overide]

I have a database that resides in sql with a .asp front end. it references checklists that are in a .pdf format. I take the pdf and convert to txt and then I was wanting to know if there is a script that will automatically enter this new table into SQL. So i am basically looking for a script that will enter all this info into the categories.

 

[JohnDTampaBay]

You can use bcp to import a text file using T-SQL. Depending on the data's destination table(s), you may have to import into a staging table, then do further processing on it before inserting into the categories. Good luck!

--John
-----------------------------------
Behold! As a wild ass in the desert
go forth I to do my work.
--Gurnie Hallock (Dune)