Walter
|
| Posted: 02/03/2003, 8:11 AM |
|
Hi all,
Im using CCS, apache, mySQL, and PHP. I'm trying to make an application that has the ability to allow the user to import predefined portions of a excel spread sheet into an existing mySQL database on a regular basis with the push of a button. Any help would be great!
Thanks,
Walter
|
|
|
 |
RonB
|
| Posted: 02/04/2003, 3:03 AM |
|
Take a look at php's (D)COM features. I think they will allow you to open an excel spreadsheet and recover the values you are looking for. Haven't done anything like taht myself yet but maybe this is what you are looking for?
Ron
|
|
|
|
Walter
|
| Posted: 02/04/2003, 10:24 AM |
|
Thanks Ron, I'm not familiar with php's (D)com but I'll look into it. If anyone out there has used this before or has any other ideas I'd love to hear from you.
Thanks again
|
|
|
|
kar
|
| Posted: 02/04/2003, 7:05 PM |
|
simplest method is export excel table to text file then code import program in php. (you also can use vba to automated exporting task)
|
|
|
|
|
