Online Form That Would to an Excel Database

[sherikatz]

I would like to make an online form that visitor will fill out and this i would like to go onto an excell formate database. I am also trying to do classified ads with the ability to charge the client with a shopping cart any ideas?

Thanks
sheri

[vrtlw]

I am also trying to do classified ads with the ability to charge the client with a shopping cart any ideas?

Yes, forget Excel, firstly because it is not a database solution and secondly you could integrate many more third party scripts with MySQL.

MySQL is the path to look at, opensource and many pre-made scripts.

[sherikatz]

Thanks vrtlw,

This is actually for a client of mine that wants the ability to charge subscribers to his site by credit card and also have their names in an axcel database so he can print stickers when he send them his magazine.
sherikatz

[Mardi_Gras]

Does your client expect to have more than 64,000 subscribers? Because that is the limit Excel would be able to handle...

[HelenDev]

If you use a mysql database I think you can save this into an access database and then export as excel?

I do it the other way around - create database in Access and upload to mysql.

Helen

[Mardi_Gras]

You should be able to go straight from MySQL to Excel without an intermediate stop in Access. But that doesn't eliminate the 64,000 row limit...

[sherikatz]

I have about 500 subsribers a month.
what about shopping cart?

[HelenDev]

If you want to do a shopping cart, you should use MySql. There are quite a few tutorials out there if you do a web search. You can then export your database to excel (on a regular basis) for your colleague to do his mailshots etc.

Helen.

[Fischerlaender]

There is a wonderful PHP package that allows you to generate Excel (XLS) files on the fly. I'm offering this on one of my sites for exporting a report and people love it.

Perhaps this could be a solution for you: Use MySQL (or any other RDBMS) on the website and offer your client an export option to Excel. You'd benefit from the "real" database and your client would be happy to get his Excel sheets.

PEAR: Spreadsheet Excel Writer [pear.php.net] (Should IMO also be available for Perl.)

[henry0]

just a word of caution I recently discovered that
PEAR is not (yet!) installed on every server by default
however in case of shared server you can in your own sector install your own PEAR.

[Fischerlaender]

Oh yes, this is a good reminder. It was really a pain to get this thing installed; in fact, I was installing the files the Excel Writer needed by hand one after another until it was running.

But once that is done, it is a great tool.