read/write data in ms access or ms excel - Programmers Heaven

Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!

Categories

Welcome to the new platform of Programmer's Heaven! We apologize for the inconvenience caused, if you visited us from a broken link of the previous version. The main reason to move to a new platform is to provide more effective and collaborative experience to you all. Please feel free to experience the new platform and use its exciting features. Contact us for any issue that you need to get clarified. We are more than happy to help you.

read/write data in ms access or ms excel

nimitbhedanimitbheda Posts: 1Member
hi ALL!
does any 1 know how to read /write data from ms access or ms excel using javascript.
KIndly advice for the same.

Comments

  • WeirdofreakWeirdofreak Posts: 439Member
    Without knowing how they store the data, it can't be done. And they aren't likely to store the data in any sort of way that makes it at all easy to read/write manually.

    Even if you do know, while not entirely impossible (ActiveX will let you write, and you can probably read by putting the files in an object tag and reading that) it is highly infeasible. Like making a jpeg in Notepad, only harder.

    There are probably fairly easy ways to do it in several server-side languages, but Javascript is completely the wrong tool.
  • jfaulkenberryjfaulkenberry Posts: 6Member
    [size=4]You [italic]are [/italic]able to connect to Microsoft Access using JavaScript when the HTML file is run locally and the Access .mdb file is accessible to the file system it does not work remotely due to the obvious security issues.

    I had a situation where this functionality was actually useful, so I wrote a JavaScript library to simplify the process. This library allows you to execute SQL queries in a single command with the option of selecting the output format of the result-set from choices including [italic]JSON[/italic], [italic]XML[/italic], and [italic]HTML[/italic].

    I had a great deal of difficulty finding information or examples of how to connect to Access, so I decided to share my code with the world...

    The library is called [u][italic][b][link=http://www.accessdb.org/]ACCESSdb[/link][/b][/italic][/u] and you can get it here: [link=http://www.accessdb.org/]http://www.accessdb.org/[/link][/size]
  • jfaulkenberryjfaulkenberry Posts: 6Member
    This post has been deleted.
  • jfaulkenberryjfaulkenberry Posts: 6Member
    This post has been deleted.
Sign In or Register to comment.