Import Excel file into MySQL database

[rcb845@yahoo.fr]

Hi everybody in the php community,

I am relatively new in this field, and one of my first challenge is the following :

Importing an Excel file, containings URL, into a MySQL database.

It must be the simplest process possible for the end user, avoiding as far as
possible all steps of converting and/or transforming files.
Of course, we want to preserve the identity of the URL.

Is there anybody who can help me or give me tricks to do this function ?

Tks in advance for all your suggestions and best regards

RCB845

[Markus Ernst]

Re: Import Excel file into MySQL database

rcb845@yahoo.fr wrote:[color=blue]
> Hi everybody in the php community,
>
> I am relatively new in this field, and one of my first challenge is
> the following :
>
> Importing an Excel file, containings URL, into a MySQL database.
>
> It must be the simplest process possible for the end user, avoiding
> as far as possible all steps of converting and/or transforming files.
> Of course, we want to preserve the identity of the URL.
>
> Is there anybody who can help me or give me tricks to do this
> function ?
>
> Tks in advance for all your suggestions and best regards[/color]

You might be interested in having a look at the conversion classes at
phpclasses.org:

http://phpclasses.php-start.de/browse/class/35.html

There is a MS file converter class; I have never tried it out yet.

HTH
Markus

[Tim Tyler]

Re: Import Excel file into MySQL database

rcb845@yahoo.fr <rcb845@yahoo.f r> wrote or quoted:
[color=blue]
> Hi everybody in the php community,
>
> I am relatively new in this field, and one of my first challenge is the
> following :
>
> Importing an Excel file, containings URL, into a MySQL database.
>
> It must be the simplest process possible for the end user, avoiding
> as far as possible all steps of converting and/or transforming files.
> Of course, we want to preserve the identity of the URL.
>
> Is there anybody who can help me or give me tricks to do this function ?[/color]

Perhaps start at:

http://sourceforge.net/projects/phpexcelreader/

--
__________
|im |yler http://timtyler.org/ tim@tt1lock.org Remove lock to reply.

[Tom]

Re: Import Excel file into MySQL database

Try the MyODBC driver at:

http://dev.mysql.com/downloads/connector/odbc/3.51.html

<rcb845@yahoo.f r> wrote in message
news:18b577b2.0 409030027.7b346 c18@posting.goo gle.com...[color=blue]
> Hi everybody in the php community,
>
> I am relatively new in this field, and one of my first challenge is the
> following :
>
> Importing an Excel file, containings URL, into a MySQL database.
>
> It must be the simplest process possible for the end user, avoiding as far
> as
> possible all steps of converting and/or transforming files.
> Of course, we want to preserve the identity of the URL.
>
> Is there anybody who can help me or give me tricks to do this function ?
>
> Tks in advance for all your suggestions and best regards
>
> RCB845[/color]

[rcb845@yahoo.fr]

Re: Import Excel file into MySQL database

I thank you all of you to have taken the time to give me some
informations about this job of importing Excel file into MySql
database.
It has been very helpful, I have also found this URL

http://www.infres.enst.fr/~danzart/mysql/mysqlimporte.phtml

that gives a script to do this job.
I have adapted it to my needs and it works.

Tks and best regards
RCB845