Re: Excel Spreadsheet as a datasource (Using Excel thru COM)

I'e done this using COM, and hacked together a little PHP class to do some things like inserting values and starting/stopping excel. See the code for more of an idea: http://hurring.com/code/php/excel_class/ (Note: it is v0.1a, which basically means i wrote it on Tuesday :-) check back at my site for more updates in the comign days/weeks) (Im using this now in combination with GTK to develop a "standalone" app for a Win32 machine. Excel is great becuase the managers can simply open the file and print it and dont have to use a separate program to generate reports) -- Scott Hurring <scotth at eac dot com> Systems Programmer EAC Corporation --- "Ron Herhuth" <Ron.Herhuth@tatumcfo.com> wrote in message news:503ABD6BCDA1B34D8FB05C65AC666CEF7397@exchange.tatumlink.com... Has anyone successfully used an Excel spreadsheet as a datasource? I realize that it is a flimsy datasource but I have a need to quickly and dynamically take the information stored in spreadsheets and manipulate the data and write them to a SQL database. I would be grateful for any assistance or information on how to do this. Thanks, Ron