Purchase Solution

Microsoft Access: Importing Excel Problem

Not what you're looking for?

Ask Custom Question

Please see attached.
Please help import the data in Excel to the table in Access. There are 6 tables in Access (Contacts, Customer, Orders, Products, SalesRep and Territories) and I also created 6 sheets in Excel for the data for table. But for some reason I can not import the data in to Access.

(Since I can not attach Access file here, I changed the file extension to Excel "Access.XLS". So please change it Access.mdb when open).

Attachments
Purchase this Solution
Solution Summary

The solution assists with solving the importing problem through Excel.

Purchase this Solution
Free BrainMass Quizzes
Javscript Basics

Quiz on basics of javascript programming language.

Java loops

This quiz checks your knowledge of for and while loops in Java. For and while loops are essential building blocks for all Java programs. Having a solid understanding of these constructs is critical for success in programming Java.

Basic Networking Questions

This quiz consists of some basic networking questions.

C# variables and classes

This quiz contains questions about C# classes and variables.

Basic UNIX commands

Use this quiz to check your knowledge of a few common UNIX commands. The quiz covers some of the most essential UNIX commands and their basic usage. If you can pass this quiz then you are clearly on your way to becoming an effective UNIX command line user.

View More Free Quizzes
Related BrainMass Solutions

  • MS Access

    Aside from the integration of Microsoft Access with its co-MS Office applications such as Word and Excel, Access can also be integrated in other applications such as accounting software and business applications.

  • What are file types?

    For example you can import dbase, Excel spreadsheets, and other data files into Microsoft Access for reporting or data manipulation. File types come from the individual programs during the install.

  • interface features

    Microsoft Word ? Microsoft Excel ? Microsoft PowerPoint ? Microsoft Outlook 1. The common user interface and features in the Microsoft Office application: In Microsoft Office suite, the individual applications share many common features.

  • Microsoft Office applications

    Be sure to list your installed version for all of these required applications: Microsoft Word Microsoft Excel Microsoft PowerPoint Microsoft Outlook 1.

  • Capabilities of Excel

    Microsoft Excel is a spreadsheet application available from the Microsoft Office suite of products. (Microsoft, 2011).

  • Data storage methods

    Does the file need to be imported by other applications that you didn't write (Excel, Access, etc.)? This can be accomplished with either a sequential access file or a commercial database.

  • Database Concept for a Single User

    - Like Excel, and unlike other Office components such as Microsoft Word and Internet Explorer, Access is commonly used as the basis for utilities and applications.

  • Retail company to convert data in Microsoft Excel spreadsheets

    451972 Retail company to convert data in Microsoft Excel spreadsheets Explain the usefulness and benefits for a retail company to convert data held in Microsoft Excel spreadsheets into a relational database using Microsoft Access.

  • Research software licensing in general

    This version offers every Office application: Microsoft Office Word 2007, Microsoft Office Excel 2007, Microsoft Office PowerPoint 2007, Microsoft Office Outlook 2007 with Business Contact Manager, Microsoft Office Access 2007, Microsoft Office Publisher

View More Related Solutions