Forum home » Delegate support and help forum » Microsoft Access Training and help » Import
|
|
|
The UK's most regular Training information: See also: |
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Import
Resolved · Low Priority · Version 2003
Reply Thu 17 Jul 2008, 16:48Delegate Katherine said...
Katherine has attended:
Access Introduction course
Access Intermediate course
Import
How do you import data from excel?
For upcoming training course dates see: Pricing & availability
RE: Import
Hi Katherine,
Welcome to the forum, Thank you for your post.
In answer to your question:
1. Make sure the Microsoft Excel data is in list format: each column must have a label in the first row and contains similar facts, and there are no blank rows or columns within the list. (Blank row or column means end of data)
2. Close the Excel workbook that contains the data you want to use in Microsoft Access.
3. In Access, open the database where you wish to copy the Excel data.
4. On the Access File menu, >Get External Data, and then click Import.
5. In the Import dialog box, change to Microsoft Excel in the Files of type box.
6. In the Look in list, navigate to the file you want to import, and then double-click the file.
7. The Spreadsheet Import wizard will open, follow the steps as indicated.
I hope that has helped, regards Pete
|