Access or Excel database through HTML

Question

im currently trying to create a database on either access or excel that can take the data imputed into an HTML form and puts it into the access or excel file stored onto the cloud. For those of you who may be interested, its intended to be used in FRC for scouting data. I can't have wifi so im wanting to have the html file on the phones to input data, they fill out the form and when they hit submit the data goes into the access or excel file. Is this even possible? And if so how?

Answer 1

I am unfamiliar with SQL, what is it and where can i find it? Would the web app, or html file, have to be online itself?

and yes, FRC does = FIRST Robotics Competition and it is very cool, probably the single coolest thing i have done in high school. I like to reference frc in my posts because you never know when there may be an alumni frc student who once had the same problem and got through it

Answer 2

If you mean: can I write ANY app using ANY technology that writes its data to an Access of Excel file on OneDrive or its cousins, the answer is no.

Relaxing that a bit, you can definitely have an Office 365 account of the right flavor to include Access web apps, and create a web app that saves data to a cloud database (SQL Azure), and that web app could be accessed from any device including phones. Why don't you get a free trial and check it out. That data is later accessible from Excel or Access client app, just like any SQL database would.

FCR = First Robotics Competition? Cool!