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