I have a text file containing 8000 ID's and names I need to import to sql and I really don't wanna do it by hand... I first thought of doing the ID's first then the name later which would work except I don't know myself how to read a file and insert each line into the database and can't find anything online...
[Actually thinking of it, I could just create the ID's to the database with a while() but the names are still an issue...]
Can anyone assist in pulling a text file w/ multiple lines into a database?
[Actually thinking of it, I could just create the ID's to the database with a while() but the names are still an issue...]
Can anyone assist in pulling a text file w/ multiple lines into a database?