Loading tab-delimited text files into MySQL

[Good Oyster]

Back when I was using Access, I used to be able to link to a tab-delimited .txt file as a table, and then run a script to extract the data and place it in a real table.

I find myself needing such an option now using MySQL, but what I thought would work wouldn't:

LOAD DATA LOCAL INFILE 'd:/filepath/test.txt' INTO TABLE testtable

Using the above SQL statement, I get the following error:

"General error: The used command is not allowed with this MySQL version"

I've been told this may be due to some security concerns in a shared environment. If this is true, is there another way to go about this?

In order to suggest a solution, it may help to know the following:
Every day a couple of .txt files are downloaded from an external server. They contain data I need to place in a MySQL database. Right now, I am using Access to link to them as tables, then using a script to transfer the data to MySQL from Access. I want to totally get away from Access.

Any suggestions?

 

[Good Oyster]

Well, looks like I stumped everyone! But never-the-less, I found my own solution using CFMX (the cfhttp tag). I will soon be totally Access free!