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
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
Related Q & A:
- How do I make a copy of an existing Yahoo group rather than creating it from scratch?Best solution by Yahoo! Answers
- How do I add a new e-mail account to my existing account?Best solution by answers.yahoo.com
- If I have a form, such as an application, how can I fill it out using my computer?Best solution by answers.yahoo.com
- How do I add a new stock to an existing portfolio?Best solution by chegg.com
- How do I delete a comment that I made on a video in YouTube?Best solution by ChaCha
Just Added Q & A:
- How many active mobile subscribers are there in China?Best solution by Quora
- How to find the right vacation?Best solution by bookit.com
- How To Make Your Own Primer?Best solution by thekrazycouponlady.com
- How do you get the domain & range?Best solution by ChaCha
- How do you open pop up blockers?Best solution by Yahoo! Answers
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.