Script to enter data to sql table

Hi all,

I am wondering how easy it is and if so how to have a text file read in externally as data in my sql database.

eg I have a text file in the same directory as my sql database is stored.

It contains circuit reading numbers:

25
24
25
30
40
45

How could I write some sort of script that when I click on it would extract these numbers and place them into my circuit readings table in my database? I am a novice so have no idea where to begin.

So from above 25 would become Circuit1, 24 Circuit 2 etc as a new row in my Circuit readings table.

Thanks for any advice.
Phil

I think you probably want to use SQL's BULK INSERT command.

http://msdn.microsoft.com/library/de...t_bcp_2e5s.asp
http://msdn.microsoft.com/library/de...ba-bz_4fec.asp