Page 1 of 1

can i use excel as db

Posted: Tue Sep 12, 2006 2:56 am
by itsmani1
haya..

i want to use excel with php as database can i do so? if i can please tell me how is it possible.
thanks

Posted: Tue Sep 12, 2006 3:05 am
by volka
excel is a spreadsheet app, not a database.

Posted: Tue Sep 12, 2006 3:06 am
by bob_the _builder
Hi,

Im not aware if you can do that, but u can certinally save your excel doc as csv (comma separated values) and then parse that file thru php.

hth

Posted: Tue Sep 12, 2006 4:54 am
by onion2k
Yes you can. You'll need to use an ODBC connection.

Posted: Wed Sep 13, 2006 4:07 am
by itsmani1
How can i read excel file row wise? means i want to read first row and then 2nd row and then 3rd row

Thanks

Posted: Wed Sep 13, 2006 5:39 am
by onion2k
itsmani1 wrote:How can i read excel file row wise? means i want to read first row and then 2nd row and then 3rd row
Using odbc_fetch_row() (or odbc_fetch_object(), odbc_fetch_into(), etc).