Results 1 to 2 of 2

Thread: Script to enter data to sql table

  1. #1

    Thread Starter
    New Member
    Join Date
    Apr 2006
    Posts
    8

    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

  2. #2
    I'm about to be a PowerPoster! mendhak's Avatar
    Join Date
    Feb 2002
    Location
    Ulaan Baator GooGoo: Frog
    Posts
    38,174

    Re: Script to enter data to sql table


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width