Import Excel file into MySQL database

[rcb845]

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]

rc****@yahoo.fr wrote:

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

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]

rc****@yahoo.fr <rc****@yahoo.fr> wrote or quoted:

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 ?

Perhaps start at:

http://sourceforge.net/projects/phpexcelreader/
--
__________
|im |yler http://timtyler.org/ ti*@tt1lock.org Remove lock to reply.

[Tom]

Try the MyODBC driver at:
http://dev.mysql.com/downloads/connector/odbc/3.51.html

<rc****@yahoo.fr> wrote in message
news:18**************************@posting.google.c om...

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

[rcb845]

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/m...limporte.phtml

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

Tks and best regards
RCB845