Importing Data from Excel

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

Resolved · Low Priority · Version 2003

7 posts

ReplyThu 10 Sep 2009, 14:31Delegate Lee said...

Lee has attended:
Excel Advanced course
Access Introduction course
Access Intermediate course

Importing Data from Excel

What is the easiest way of importing data from Excel into Access?

Version	Date	Location	Places available	Book	Next place rate (£)		List price
Access Intermediate 1 day course
Version	Date	Location	Places available	Book	Pay by Card	Pay by Invoice	List price
2007	Tue 3 Aug 2010	Bloomsbury	1		£215	£220	£235
2003	Fri 20 Aug 2010	Bloomsbury	7		£190	£195	£235
2007	Fri 27 Aug 2010	Bloomsbury	9		£180	£185	£235
2010	Thu 16 Sep 2010	Bloomsbury	7		£250	£255	£299
2007	Wed 29 Sep 2010	Bloomsbury	8		£176	£181	£235
2003	Fri 8 Oct 2010	Bloomsbury	10		£142	£157	£235
Full Schedule: See all 35 Access Intermediate course dates. Bookings currently available until 28th September 2011.

825 posts

ReplyFri 11 Sep 2009, 10:40Trainer Stephen said...

RE: Importing Data from Excel

Hi Lee

Thank you for your question

There is a standard importing wizard that will do this for you

Click on file Get-Get External Data-Import.

In the resulting dialog box, select the file type as Excel Spreadsheet, and then browse to find the relevant file and click OK

The wizard will then walk you through the process, checking on data types etc. and will finish by creating an Access table based on the spreadsheet

Regards

Stephen

Thu 17 Sep 2009: Automatically marked as resolved.

· Making The Transition To Access - Why You Might Need It
· How To Create A Combo Control On An Access Form
· Build International Databases With Microsoft Access
· Learn about Subqueries in Access Courses
· Some Things You May Not Know About Relational Databases

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

Access tip:

Combo box for finding records

You can use a combo box in a form to look up a record. If you place the comb box in the Form header, by then selcting they a field type from the drop down loist, you will see the record for it

View all Access hints and tips