Quick Links ▼

Customer: Sign in
Delegate: Sign in
Trainer: Log in

Forum home » Delegate support and help forum » Microsoft Access Training and help » Importing Data from Excel to Access

	98.1 % recommend us
	More live stats...

The UK's most regular
instructor-led training courses.

Training information:

Importing Data from Excel to Access

Resolved · Low Priority · Version 2003

Reply Mon 23 Aug 2010, 07:28Delegate Matthew said...

Matthew has attended:
Access Introduction course

Importing Data from Excel to Access

I'm having a problem getting Access to do this.

Possibility is that Access is 97 version (due to a third party stock control system that must be installed)

Or do I need to Format the Fields before I can import?

For upcoming training course dates see: Pricing & availability

Reply Wed 25 Aug 2010, 09:38Trainer Simon said...

RE: Importing Data from Excel to Access

Hi Matthew,

Thank you for your question.

Can I confirm it is Access 97 you have installed and this is installed as it only works with your third party stock control software?

Is there a error message when you try and import the data? If so what is the message?

Regards

Simon

Tue 31 Aug 2010: Automatically marked as resolved.

Access articles

· Interested In The Golden Rules For Building Access Databases?
· Repetitive Tasks? Let Access Do The Hard Work For You
· What Are The Benefits Of Publishing Your Microsoft Access Database?
· Getting to grips with Access 2007's Opening Screen and User Interface
· Express Yourself With Microsoft Access

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

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