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
screechyboy [ Mi, 09 April 2008 17:13 ] [ ID #1938956 ]

Re: Import Tab delimited .txt file into SQL database

screechyboy [at] 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 [at] attglobal.net
==================
Jerry Stuckle [ Mi, 09 April 2008 18:48 ] [ ID #1938960 ]
PHP » alt.php » Import Tab delimited .txt file into SQL database

Vorheriges Thema: php and mySql
Nächstes Thema: MySQL server running, PHP can't connect