import files into mysql

[rakennedy75]

I am looking for away to import tab delimited or comma delimited files into my mysql, kind of like phpMyAdmin does. This uses a load in command to import the files into the appropriate fields (of course I already have a database built for this)

here is the mySql command that process that send the file into the data base

load data infile 'myPath/myDomain/myText.txt' into table myTable;

I just need a direction on how to approach writing a php script that would take this file and break it down and to enter it into the database. I am not sure if this is a complicated process or not. I have been playing around with fgetcsv function and thought this might be a way to break the files down. Am I on the right path, if not please let me know.

I appreciate your time.
Thanks
Ray

[sidney]

$lines = file('http://www.example.com/file.txt');// or relative path
forech($line as value)
{
splitdata line into table row items
create query to insert line to database
insert line
}