Importing data

Resolved · Low Priority · Version Standard

Importing data

Jonjo has attended:
Access Introduction course
Access Intermediate course

by - delegate Jonjo [1 post] (2008 Feb 7 Thu, 12:06) Reply

How do I import my existing data into my new more efficient database table?

Version	Date	Location	Places available	Book	Next place rate:
Access VBA 2 day course
Version	Date	Location	Places available	Book	Card	Invoice
2003	2009 Jan 8 Thu + 9 Fri	Southwark	4	book now	£475	£485
2003	2009 Feb 5 Thu + 6 Fri	Southwark	6	book now	£450	£485
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
2003	2009 Jun 4 Thu + 5 Fri	Southwark	8	book now	£275	£399
Full Schedule: See all 11 Access VBA course dates. Bookings currently available until 5th November 2009.

RE: Importing data

by - trainer Pete platinum contributer [816 posts] (2008 Mar 18 Tue, 10:54) Reply

Hi Jonjo, Thanks for the post, In answer to your question, if you are importing from Access to Access the operation can be carried out from the File> Get External Data and choose the option Import, navigate to your chosen database and choose the Tables, Queries, Forms, Reports and other objects that you wish to import. Click OK when you have made your choices. The objects imported will then be shown in the relevant object selection areas in the database window. I hope that helps best regards Pete

· 3 Useful Things You'll Learn in Microsoft Access Training Courses
· How To Find Good Access Database Courses In London
· When Is Microsoft Access Not The Best Choice For Your Business?
· Reasons to Consider Microsoft Access Training
· Why a Microsoft Access Course Could Change the Way You Do Business

Please browse our web site to find out more about
ms-access-course 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

Rate this page: