I am attempting to put data from an excel file into a database. I have saved the excel page as a Tab delimited file on my hard drive. I then use a program to move the file on to my Host server. - No problems
The bit I am struggling with is how I obtain the data in the file and input it into the database.
I have used
$query = "LOAD DATA INFILE '/home/cale46/public_html/company/time/time.txt' INTO TABLE Pet ";
$result = mysql_query($query) or die ("no insert");
but it doesn't work.
I was therefore wondering if it was my coding that was rubbish or the data source
thx in advance
