Export

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

Resolved · Low Priority · Version Standard

Export

Faith has attended:
Access Introduction course

by - delegate Faith [3 posts] (2008 Mar 10 Mon, 17:13) Reply

How do you export from excel to access table

Version	Date	Location	Places available	Book	Next place rate:
Access Intermediate 1 day course
Version	Date	Location	Places available	Book	Card	Invoice
2003	2008 Sep 2 Tue	Southwark	3	book now	£210	£215
2003	2008 Sep 9 Tue	Bloomsbury	6	book now	£193	£215
2002/XP	2008 Sep 11 Thu	Tooting	0	FULL
2003	2008 Sep 19 Fri	Bayswater	5	book now	£195	£205
2007	2008 Sep 23 Tue	Bloomsbury	5	book now	£212	£224
2002/XP	2008 Sep 24 Wed	Tooting	0	FULL
Full Schedule: See all 73 Access Intermediate course dates. Bookings currently available until 24th November 2009.

RE: export

by - trainer Pete platinum contributer [799 posts] (2008 Mar 19 Wed, 12:58) Reply

Hi Faith, Thank you for the post, In answer to your question to import a table from Excel; Choose the menu command File>Get External Data>Import, From the dialog box, change the Files of Type to Excel and navigate to find the workbook of your choice, follow the steps in the wizard to choose the sheet to import. Ensure that the sheet follows the rules of database creation ie field name column headers, no gaps between header and data etc. I hope that helps, best regards Pete.

· Microsoft Access Tighten your Security Controls
· Want to Become the Office Hero? MS Project Training Could be the Answer
· Access VBA Training Adds Power to your Databases
· Microsoft Access Training Opens Doors
· How Reorganising Your Data Can Take Your Business to the Next Level

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

Access tip:

Label printing

You can create a report in Access for printing labels All you have to do is is click New under the Reports object and then select Label Wizard and follow the steps

View all Access hints and tips