Import Tab delimited .txt file into SQL database

Hi,

Does anyone have any sample code to help me achieve the above?

I have an upload form which copys the txt file to a particular folder
on my server i now need to seperate each line by tabs and copy this
data into my databases corrosponding fields.

I have google searched and got close but some of the fields are not in
the correct format or blank. I believe this to be becuase it is not
seperating the tabs correctly any links or code would be a great help.

Steve

Re: Import Tab delimited .txt file into SQL database

screechyboy@googlemail.com wrote:
> Hi,
>
> Does anyone have any sample code to help me achieve the above?
>
> I have an upload form which copys the txt file to a particular folder
> on my server i now need to seperate each line by tabs and copy this
> data into my databases corrosponding fields.
>
> I have google searched and got close but some of the fields are not in
> the correct format or blank. I believe this to be becuase it is not
> seperating the tabs correctly any links or code would be a great help.
>
> Steve
>

In you searches, didn't you find any MySQL newsgroups - such as
comp.databases.mysql?

--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstucklex@attglobal.net
==================