Is it possible to have HTML as FRONT END & Excel as BACK-END database?

[Chandru Thiyaga]

I have created data entry tool in excel for our daily shift report details for the whole year. But the excel size seems to be so BIG and it becomes slow in calculations & saving.

Is that possible to have HTML as front end data entry page & add the details to back-end Excel database by clicking a button in HTML?

Pls advice on this.

[AutumnsDecay]

Perhaps you could give us a bit more information?

I mean you can certainly make a backend application that allows for reading and exporting of an Excel file type if you can find the library for it. I'm sure it exists somewhere.

It wouldn't be a pure Excel environment, though. You'd likely use PHP and MySQL to store the variables for the document, and then when the doc is opened, it requests the variables from the site. I believe Excel has this type of feature, but I'm not 100% sure. I've used Excel maybe twice in my life.

But hopefully this gives you a basic 'this should be possible' or not idea.

[Basav]

Hello Chandru,

I'm also looking for same kind, i meant , need to use HTML as front end and Excel as Database.

Please suggest me

[Rabbit]

You could try to use Excel as a back end... but everyone with experience in databases will tell you not to. If you think that using a web interface while keeping the data in Excel will speed things up for you, you're mistaken on that point.

[PsychoCoder]

You would need a language between the HTML and your data source. HTML is simply a markup language, not a programming language.

Personally I would try and avoid using Excel as your backend, just maintaining it would be a nightmare. Check out MySql or SQL Express

[Basav]

Dear Rabbit and PhychoCoder,

Thanks for your prompt reply..

Here going to use this application on stand alone system rather on Network or web.

All that i need to do is just conceal the Excel here.

We can achieve this in Xcelcious but unfortunately it wont support any Macro in this.

Thanks,
Basav

[Rabbit]

I just realized this was a thread from two years ago. Please do not hijack and bump old threads. If you have a question, create a new one. Please read the FAQ before you do.

[Basav]

I had posted the new thread too.

you can check the below link.

http://bytes.com/topic/access/answer...se#post3738135

Since Chandru had also asked same question, just checking whether if he got any solution or not..
you can check my thread addressing him directly..