Microsoft Access

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

Resolved · Low Priority · Version Standard

Microsoft Access

Ben has attended:
Access Introduction course
Access Intermediate course

by - delegate Ben [4 posts] (2008 Feb 21 Thu, 16:32) Reply

How can I import many tables into one table in an automatic way?

Version	Date	Location	Places available	Book	Next place rate:
Access Advanced 1 day course
Version	Date	Location	Places available	Book	Card	Invoice
2003	2008 Aug 29 Fri	Bayswater	0	FULL
2003	2008 Sep 3 Wed	Southwark	1	book now	£235	£240
2007	2008 Sep 24 Wed	Bloomsbury	0	FULL
2003	2008 Oct 8 Wed	Southwark	5	book now	£219	£235
2003	2008 Oct 24 Fri	Bloomsbury	7	book now	£190	£224
2003	2008 Oct 29 Wed	Bayswater	8	book now	£110	£224
Full Schedule: See all 55 Access Advanced course dates. Bookings currently available until 25th November 2009.

RE: Microsoft Access

by - trainer Pete platinum contributer [799 posts] (2008 Mar 18 Tue, 15:29) Reply

Hi Ben, Thank you for your post, In response to your question, you can import many tables into a database using the File>Get External Data > Import and then choosing multiple tables from your source; however I am not aware of a method of importing many tables into one, I think this would have to be accomplished by creating a query from the various tables and then undertaking a make table query. Sorry cant be more helpful, but perhaps that will help, best regards Pete.

· Quick Access Course: Creating a Customer Contact Database in 8 Simple Steps
· Access VBA Training Adds Power to your Databases
· Turning your Spreadsheets into Interactive Data Warehouses with MS Access Courses
· Microsoft Access Cheat Sheet: Tips and Shortcuts
· Microsoft Access Training Opens Doors

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

Access tip:

Prefixed Autonumbering

When using Date Type = Autonumber as a primary key, clients may require autonumbering to be prefixed with a letter.

For example, P001, where P is the prefixed letter

Instructions
Step 1. Create Field Name
Step 2. Set Data Type to Autonumber
Step 3. Within Field Property General tabsheet,
enter Format property as [backslash]P000

View all Access hints and tips