Quick Links ▼

Bookmark page

Printable version

Customer: Sign in
Delegate: Sign in
Trainer: Log in

Forum home » Delegate support and help forum » Microsoft Access Training and help » Access

	98.1 % recommend us
	More live stats...

The UK's most regular
instructor-led training courses.

Training information:

Access

Resolved · Low Priority · Version 2003

Reply Thu 20 Nov 2008, 16:49Delegate Patrick said...

Patrick has attended:
Access Introduction course
Access Intermediate course

Access

How do I import Excel data into a table?

For upcoming training course dates see: Pricing & availability

Reply Mon 24 Nov 2008, 11:53Trainer Simon said...

RE: Access

Hi Patrick,

Thank you for your question.

The first thing you need to check is if the Excel data is arranged in columns.

If you want to import data from Excel, then use the File command and then 'Get External Data'. Change the File Type to Excel files. Search for your Excel source and select it. A wizard then begins which will take you through the guided steps.

You will be asked various questions about the Excel data.

I hope this answers your question.

Regards

Simon

Access articles

· When Is Microsoft Access Not The Best Choice For Your Business?
· Find Microsoft Access Templates For Any Task
· Protect Sensitive Access Databases With A Password
· Help Business To Go Global With Shared Databases
· So what's new in Access 2007?

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

Access tip:

Splittng a database

Split your database into two (at least).

Keep all of your code, forms, reports, etc. in one 'code' database and all of your tables in another 'data' database which is then linked to the 'code' database.

This makes modifications, updates and back-ups that much easier and allows you to work on a new version of your 'code' database without affecting existing users. It also makes it easier should you wish to convert a single user databases into a multi-user networked version.

View all Access hints and tips