<div>
probably you could start by chopping the Excel...maybe a field was interpreted erroneously and <br />
'bombs out' on import
</div>


probably you could start by chopping the Excel...maybe a field was interpreted erroneously and
'bombs out' on import

Developer

Murray Brown

<div>
you can have pretty problems here if the excel file has non printable characters other than line feed etc I learned over several weeks of scratching my head. usually though when you import or copy but not linking. until you touch a field with said characters.
</div>


you can have pretty problems here if the excel file has non printable characters other than line feed etc I learned over several weeks of scratching my head. usually though when you import or copy but not linking. until you touch a field with said characters.

<div>
<div class="content wysiwyg-content">
Hi<br />
I am getting the following error when trying to import Excel data into Access with no explanation of what is causing the error. Is there a way to get more detail than this<br />
<br />
<a href="https://filedb.experts-exchange.com/incoming/2019/11_w48/1437392/Image1.JPG" target="_blank" title="1 (88 KB)"><img alt="1" class="file-block lazyload" style="max-width: 800px;" data-src="https://filedb.experts-exchange.com/incoming/2019/11_w48/800_1437392/Image1.JPG" /></a>
</div>
</div>


Image1.JPG

Hi
I am getting the following error when trying to import Excel data into Access with no explanation of what is causing the error. Is there a way to get more detail than this



Access Import from Excel not working

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.