can i use excel as db

PHP programming forum. Ask questions or help people concerning PHP code. Don't understand a function? Need help implementing a class? Don't understand a class? Here is where to ask. Remember to do your homework!

Moderator: General Moderators

Post Reply
User avatar
itsmani1
Forum Regular
Posts: 791
Joined: Mon Sep 29, 2003 2:26 am
Location: Islamabad Pakistan
Contact:

can i use excel as db

Post 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
User avatar
volka
DevNet Evangelist
Posts: 8391
Joined: Tue May 07, 2002 9:48 am
Location: Berlin, ger

Post by volka »

excel is a spreadsheet app, not a database.
Last edited by volka on Tue Sep 12, 2006 3:06 am, edited 1 time in total.
bob_the _builder
Forum Contributor
Posts: 131
Joined: Sat Aug 28, 2004 12:25 am

Post 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
User avatar
onion2k
Jedi Mod
Posts: 5263
Joined: Tue Dec 21, 2004 5:03 pm
Location: usrlab.com

Post by onion2k »

Yes you can. You'll need to use an ODBC connection.
User avatar
itsmani1
Forum Regular
Posts: 791
Joined: Mon Sep 29, 2003 2:26 am
Location: Islamabad Pakistan
Contact:

Post 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
User avatar
onion2k
Jedi Mod
Posts: 5263
Joined: Tue Dec 21, 2004 5:03 pm
Location: usrlab.com

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