Access 2007

The UK's most regular instructor-led training courses.
Training information: access 2000 training · Access training · Microsoft Access Training
See also · microsoft access training · access vba courses · access database course

Resolved · Medium Priority · Version 2007

2 posts

ReplyMon 22 Jun 2009, 16:39Delegate Morgan said...

Morgan has attended:
Access Introduction course

Access 2007

How do you import EXCEL data into access

Version	Date	Location	Places available	Book	Next place rate (£)
Access Intermediate 1 day course
Version	Date	Location	Places available	Book	Pay by Card	Pay by Invoice
2007	Tue 23 Mar 2010	Bloomsbury	3		£224	£225
2003	Tue 30 Mar 2010	Bloomsbury	5		£199	£204
2003	Thu 22 Apr 2010	Southwark	5		£195	£200
2007	Tue 27 Apr 2010	Bloomsbury	4		£224	£225
2003	Fri 28 May 2010	Bloomsbury	9		£156	£161
2003	Wed 16 Jun 2010	Bloomsbury	8		£95	£100
Full Schedule: See all 20 Access Intermediate course dates. Bookings currently available until 17th December 2010.

870 posts

ReplyTue 23 Jun 2009, 12:11Trainer Rajeev said...

RE: Access 2007

Dear MOrgan

Thank you for attending Access 2007 Introduction course!! I hope you enjoyed the course and benefited from it.

The step of doing this is as follows:

1. Open the database where you would like the Excel data to be imported.

2. Choose External Data tab from the ribbon and then click on the Excel icon in the Import Group

3. Click on the browse button to choose the Excel file where the data will come from and then choose the file. Press Open button

4. Select the first option to have the new data imported in a new table. Press Ok button

5. Choose the Worksheet where the data will come from.

Note: Please try to ensure that the worksheet has no Main heading and subheadings. Try to have the first row in eth worksheet to have the Column headings.

6. Press Next button. Ensure that you have got the tick on First Row contains Headings especially if your first row in the worksheet has column headings. Press Next Button

7. In this step specify if you want any column not to be imported by using the check box Do not Import field (Skip). Press Next.

8. Either let Access add a Primary key or choose your eth Primary key of your own choice or simply select no Primary key. Press Next

9. Provide a relevant name for the new Table. Press Finish

I hope this has answered your query.

If this has answered your query then I would request you to please mark the question as resolved!! If not and you have a specific question related to this then please post it as a new question and we should be able to provide you the solution for it!!

Kindest Regards

Rajeev Rawat
MOS Master Instructor 2000 and 2003
MCAS Master Instructor 2007
MCT

· MS Access: Access your Personal Information with Ease
· Making The Transition To Access - Why You Might Need It
· Why consider Access Visual Basic training?
· Data validation in MS Access
· When Is Microsoft Access Not The Best Choice For Your Business?

Please browse our web site to find out more about
access 2000 training and other Microsoft training courses.