Forum home » Delegate support and help forum » Microsoft Access Training and help » microsoft access training class - How do I export data form excel to access
|
|
|
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. |
microsoft access training class - How do I export data form excel to access
Resolved · Low Priority · Version Standard
Reply Mon 6 Aug 2007, 10:41Delegate Eloise said...
For upcoming training course dates see: Pricing & availability
RE: How do I export data form excel to access
Hi Eloise
An easy way to do this is to start in Access.
Before you do so, make sure the data in Excel has the column headings in Row 1.
In Access, Click FILE > Get external Data
IMPORT
Then select the Excel file you want to import.
A wizard will start with 4 steps to assist you
1. Choose worksheet to import
2. Tick the box for Column headings in first row
3. Import to NEW Table
4. Alter any field names (you can skip this step)
5. Choose the primary key (let access add a key)
6. Give the new table a name
DONE
Regards
Richard
|
|