Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

access importing excel data

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

Access Importing Excel Data

ResolvedVersion 2003

Louise has attended:
Access Introduction course
Access Intermediate course

Access Importing Excel Data

Morning. I am trying to IMPORT Excel Data, which has 33,000 rolws. As I get to FInish I revcieve the following message

An Error Occurred trying to import file XXX.XLS File not imported.

I ahve tried it as a CSV, XLS, Making it smaller, taking out data and nothing works. DO you have any examples of why this might be happening

Louise Griffiths

RE: Access Importing Excel Data

Hi Louise, thanks for the query. That error message isn't exactly helpful is it? One reason it may be appearing is because of leading spaces in your field titles (the first row in Excel). Go through and make sure that none of your title fields in Excel have been, say, centred using the spacebar instead of the centre align tool. If there is just one space before any of those field titles Access will report this error when you try to import.

Let me know if this works,

Anthony

RE: Access Importing Excel Data

Perfect, yes that was the problem. I removed the headders and imported with no headder then added new Field Names using design view.

THanks

Access tip:

Change The Default Font in Access 2003

You can change the default font in Access 2003 so that whenever you create a new database your preferred font is automatically set.

To change the default font:

1.From the menu bar select Tools.
2.Click Options.
3.Go to the Datasheet tab:
4.In the Default font section select your preferred font from the list of fonts e.g. Arial.
5.Select your preferred size from the size menu e.g. 12.
6.Click Apply.

Click on the Tables/queries tab:
1.In the Query Design font section select your preferred font from the list of fonts e.g. Arial.
2.Select your preferred size from the size menu e.g. 12.
3.Click Apply.
4.Click OK.

The default font for Access has now been changed.

View all Access hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.1 secs.