microsoft access training course

microsoft access training course - MS Access

Resolved · Low Priority · Version Standard

MS Access

Rachel has attended:
Access Introduction course

by - delegate Rachel [2 posts] (2007 Nov 5 Mon, 16:45) Reply

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

Version	Date	Location	Places available	Book	Next place rate:
Access VBA 2 day course
Version	Date	Location	Places available	Book	Card	Invoice
2003	2008 Dec 4 Thu + 5 Fri	Southwark	3	book now	£475	£495
2003	2009 Jan 8 Thu + 9 Fri	Southwark	6	book now	£450	£485
2003	2009 Feb 5 Thu + 6 Fri	Southwark	8	book now	£275	£399
2003	2009 Mar 5 Thu + 6 Fri	Southwark	7	book now	£345	£399
2003	2009 Apr 8 Wed + 9 Thu	Southwark	8	book now	£275	£399
2003	2009 May 7 Thu + 8 Fri	Southwark	8	book now	£275	£399
Full Schedule: See all 12 Access VBA course dates. Bookings currently available until 5th November 2009.

RE: MS Access

by - trainer Richard platinum contributer [818 posts] (2007 Nov 6 Tue, 10:17) Reply

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

RE: MS Access

by - delegate Rachel [2 posts] (2007 Nov 6 Tue, 10:27) Reply

Thanks for that, that's really helpful!

RE: MS Access

by - trainer Richard platinum contributer [818 posts] (2007 Nov 6 Tue, 15:04) Reply

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

Regards

Richard