Forum home » Delegate support and help forum » Microsoft Access Training and help » Excel import data
|
|
|
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. |
Excel import data
Resolved · Low Priority · Version 2003
Reply Thu 9 Oct 2008, 17:00Delegate Mofe said...
Mofe has attended:
Access Introduction course
Excel import data
How do I import data into access from Excel?
For upcoming training course dates see: Pricing & availability
RE: Excel import data
Hi Mofe
Sorry for the delay in answering this question
To import data from Excel into Access do the following:
Make sure that the data on the spreradsheet you are importing starts with the field names(column headings) on row 1. This is so that when you import the data into Access it converts the values in this row into field names.
1. Select File, Get External Data and click Import
2.The Import dialog box appears
3. In Files of type select Microsoft Excel. Find the relevant file and click Import
4. The Import spreadsheet wizard appears. Select First row contains column headings. Click Next.
5. Select where the data is to go. Click Next.
6. Specify the information in the field and also determine if the field is to be imported. Click Next.
7. Set the Primary Key. Click Next.
8. Set the new table's name. Click Finish.
Hope this helps.
Carlos
|