I am a student trying to convert a excel spreadsheet to a Access database.

5 pts.
Tags:
Microsoft Access
Microsoft Excel
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.
ASKED: February 21, 2008  7:56 AM
UPDATED: February 21, 2008  1:13 PM

Answer Wiki

Thanks. We'll let you know when a new response is added.

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>.

Discuss This Question:  

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following