How to insert data in excel as database

[lokeshsu]

Hi all,

i need a code that will help me in saving data from html page using javascript to excel database

Regards
Lokesh

[gits]

this is not possible with JavaScript alone ... should this work on a local machine only or could a server be involved? the second option would open some possibilities, the first might have a chance with a strict IE only solution ... but no cross-browser solution then.

[lokeshsu]

Hi

i have a file in shared folder and the same file is opened by multiple users.all the user save hte data in the same database

[gits]

??? please explain exactly what your usecase is ... should the xls-file be connected 'online' to a webpage or should data from a webpage be extracted to a file or what interaction should happen?

[lokeshsu]

i am not using any server. i save the database in teh shared folder and i have excel files which is in different system when they click on a button the data in the excel file should be saved in the shared folder database.

[Banfa]

I doubt there is a way to do this, in general browsers do not allow any web-page access to the system as a security measure so there are no commands in Javascript for opening files or opening databases.

Shared folders are asking for either data corruption or a usability problems with users being locked out by other users.

Generally I would recommend you switch to a client server architecture as a more robust overall solution.

BTW what database engine are you using?