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).