Forum home » Delegate support and help forum » Microsoft Access Training and help » Access Importing Excel Data
|
|
|
The UK's most regular Training information: See also: |
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Access Importing Excel Data
Resolved · High Priority · Version 2003
Reply Mon 27 Jul 2009, 09:33Delegate 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
For upcoming training course dates see: Pricing & availability
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
Reply Mon 27 Jul 2009, 11:00Delegate 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
|