Access

Resolved · Low Priority · Version 2003

Thu 9 Oct 2008, 16:08 Delegate Jill said...

Jill has attended:
Access Introduction course
Visio Introduction course

Access

Can I import and export data into Access?

Fri 17 Oct 2008, 15:03 Trainer Simon said...

RE: Access

Hi Jill,

Thank you for your question.

To import data follow these steps:

File, Get External Data and choose Import. Change the File Type from Access to Excel and select the Excel file. Then follow the steps of the Import Wizard.

To export the data to Excel or Word follow these steps:

Select the Table or Query and go to Tools and Office Links and choose the appropriate option.

I hope this answers your question.

Regards

Simon

Training courses

	98.7 % recommend us
	More live stats...

Training information:

Access tip:

Random sampling

Data is th key to a good database, therefore checking is essential.

A good way of checking data is by random sampling. You can do this in a query, by typing the follow:
1) In the Field box create a RandonID field eg. Randon Id: Rnd(fieldname])

2) sort the field
3)Right click and chage the properties for To value to be the number of randon records you want to see.

4) Change the set to Show row for Randon ID to be False, add all the other fields you want to see and the run the query.

View all Access hints and tips

Application Training

Training ProgramsProfessional & Management Development

eLearning Solutions

Our Promotions

Our Schedule

Course Formats

Our Clients

Access

Access

RE: Access

Access articles

Access tip:

Random sampling

Training Programs
Professional & Management Development