I am a student trying to convert a excel spreadsheet to a Access database.
My questions:
How do I convert data from an excel spreadsheet to a Access Database.
How do I convert a access form to excel - Using the form as a front for data capturing.
How do I link multiple users to a access database - making allowance for data to flow simultanously into the database.
Software/Hardware used:
Software/Hardware used:
ASKED:
February 21, 2008 7:56 AM
UPDATED:
February 21, 2008 1:13 PM
Answer Wiki:
1. You'll need to create tables, then use the import functions in Access to load the data. You'll probably need to normalize the data in the Access database as Excel data usually isn't normalized.
2. Moving an Access form from Access to Excel, will be pretty tough as Excel doesn't have a form mode.
3. You can have more than one user open a single access database at the same time. Your performance will not be very good, as Access isn't designed to be a multi-user database. I would recommend using SQL Server 2005 Express as the back end, then use Microsoft Access to create forms which are linked to the SQL Server 2005 Express database. This way the data storage is handled by a system which is designed to handle multiple users at the same time and the front end is easy to design and build.
If you need more info on SQL Server 2005 Express check out the <a href="http://www.microsoft.com/sql/editions/express/default.mspx">Microsoft SQL Express web site</a> as well as <a href="http://itknowledgeexchange.techtarget.com/sql-server/">SQL Server with Mr. Denny</a>.
To see all answers submitted to the Answer Wiki: View Answer History.
RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
