How to open existing database in WebSQL?

How do I link a form made from Excel to an existing Access database?

  • My wife makes a website for her company and she wants to have an (Excel) form that can be filled out so that it automatically sends and updates an existing (Access) database. How is this done?

  • Answer:

    First of all, since you specifically mentioned "website" and "automatically sends", I assume you are wanting this to work interactively from a web page. And because this is an MS-Access database that will be updated using such data, then you will most likely need to have the website running on Microsoft's IIS (their web server product). Plus, the web pages will need to be .ASP documents and not HTML. Now to explain everything you need to know to get this to work will take at least a hundred pages of print-out. But if this is just an MS-Excel workbook, that sits on a shared area of a file server. And anyone that has access to it on the network can open and update, then that is a bit easier. It will only take two pages of text to explain what you will need to know. And there is not enough space in Yahoo Answers to give either of these two options in detail. But a Google search will show you some sites with such tutorials. .

Ostrodam... at Yahoo! Answers Visit the source

Was this solution helpful to you?

Other answers

i'm not if this is what you mean but here you go: 1. on the database go onto file, and on there somewhere there should be an option to import, click on it 2. you will now hot to choose what to import, find the file where the spreadsheet is and change the data type at the botton of the screen to Excel 2007 (or whatever you have) 3. Then you click on the spreadsheet and you have to go through some options. 4. just do it how you need it. i'm not sure if that is what you mean so i'm sorry if i'm wrong

oyyou

Just Added Q & A:

Find solution

For every problem there is a solution! Proved by Solucija.

  • Got an issue and looking for advice?

  • Ask Solucija to search every corner of the Web for help.

  • Get workable solutions and helpful tips in a moment.

Just ask Solucija about an issue you face and immediately get a list of ready solutions, answers and tips from other Internet users. We always provide the most suitable and complete answer to your question at the top, along with a few good alternatives below.