microsoft-access-course - Import data

Resolved · Low Priority · Version Standard

Mon 23 Apr 2007, 09:46 Delegate Anne said...

Anne has attended:
Access Introduction course

Import data

How do I import data from excel to access?

Mon 23 Apr 2007, 10:05 Trainer Richard said...

RE: Import data

Hi Anne

Simply click on File > Get external data> Import

Then point to the file that you want to import and follow the Import wizard.
You will need to select:
- what sheet you want
- any delimiters
- formatting
- location

Once that is complete, then Access creates a new table with your imported data.

Regards

Richard

Training courses

	98.7 % recommend us
	More live stats...

Training information:

Access tip:

Create calculated fields that work out your age

You can uset eh year function to work out the year from NOW function and then subtract it with your date of birth type field

Age=Year(Now( ))-Year([DoB])

View all Access hints and tips

Application Training

Training ProgramsProfessional & Management Development

eLearning Solutions

Our Promotions

Our Schedule

Course Formats

Our Clients

microsoft-access-course - Import data

Import data

RE: Import data

Access articles

Access tip:

Create calculated fields that work out your age

Training Programs
Professional & Management Development