98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Access Training and help » Access Importing Excel Data
Access Importing Excel Data
Resolved · High Priority · Version 2003
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
Mon 27 Jul 2009, 10:18Trainer 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
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 tip:Using the Quick Access Toolbar in Access 2010The Quick Access Toolbar is included in virtually every Office product, including Outlook 2010, Word 2010, Excel 2010, and PowerPoint 2010. |
