Forum home » Delegate support and help forum » Microsoft Access Training and help » Importing files
|
|
|
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. |
Importing files
Resolved · Low Priority · Version 2003
Reply Mon 6 Apr 2009, 15:56Delegate Natalie said...
Natalie has attended:
Access Introduction course
Importing files
How do you import excel spreadsheets into Access?
For upcoming training course dates see: Pricing & availability
RE: Importing files
Hi Natalie
To Import a worksheet to a database as a table you do the following:
1. Select File, Get External Data and click Import
2. In the Import dialog box, select Files of Type Microsoft Excel
3. Find the excel file you require and click Import
4. In the dialog box select the worksheet which you want to Import
5. In the next window select First Row Contains Column Headings (NB Your column headings in the Excel sheet should be in row 1 for access to recognize those names as the field names
6. Click Next
7. Change the table name if required
8. Click Finish
Your Excel table has been imported
Hope this helps
Carlos
|