Access Importing Excel Data

Resolved · High Priority · Version 2003

Mon 27 Jul 2009, 09:33 Delegate Louise said...

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

Mon 27 Jul 2009, 10:18 Trainer Anthony said...

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

Mon 27 Jul 2009, 11:00 Delegate Louise said...

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

Training courses

	98.7 % recommend us
	More live stats...

Training information:

Access tip:

Using the Quick Access Toolbar in Access 2010

The Quick Access Toolbar is included in virtually every Office product, including Outlook 2010, Word 2010, Excel 2010, and PowerPoint 2010.

You will find the Quick Access Toolbar in the top-left side of the window. To begin, click the Customize button (it's the little black arrow at the end of the toolbar).

Simply click the commands you want to include.

Virtually any command can be added to the Quick Access Toolbar. Click the More Commands option and a new window will open from where you can browse the commands including those not on the ribbon.

View all Access hints and tips