View Full Version : how to connect MS-excel with PHP????

06-26-2005, 08:57 AM
i am thinking to use ms-excel as database......can anybody give me the tutorials about how to connect the excel using php..........

06-30-2005, 09:13 PM
the easiest is to define a DataSourceName to the excel sheet. The sheet has to contain a named range, which the driver will treat as the table.
from the php-page, you can then make a dsn-connection to the datasource and eat your heart out