Quick Links ▼

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

Forum home » Delegate support and help forum » Microsoft Access Training and help » microsoft access training course - MS Access

	98.1 % recommend us
	More live stats...

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

Training information:

microsoft access training course - MS Access

Resolved · Low Priority · Version Standard

Reply Mon 5 Nov 2007, 16:45Delegate Rachel said...

Rachel has attended:
Access Introduction course

MS Access

Can I use data from MS Excel in MS Access? Is there a way of importing data from MS Excel to Access?

For upcoming training course dates see: Pricing & availability

Reply Tue 6 Nov 2007, 10:17Trainer Richard said...

RE: MS Access

Yes, you can import Excel data to Access.

Use FILE > GET EXTERNAL DATA > IMPORT

This will start an import wizard, which will guide you throught the import process.

regards

Richard

Reply Tue 6 Nov 2007, 10:27Delegate Rachel said...

RE: MS Access

Thanks for that, that's really helpful!

Reply Tue 6 Nov 2007, 15:04Trainer Richard said...

RE: MS Access

Pleasure, if you have any other questions, feel free to add them to the forum.

Regards

Richard

Access articles

· Learn The Secrets Of Customising An Autonumber Primary Key In Access
· The Three Classes of Databases
· Microsoft Access Tighten your Security Controls
· Getting to grips with Access 2007's Opening Screen and User Interface
· Learn About Action Queries In Access

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