View Single Post
  #1 (permalink)  
Old April 16th, 2018, 04:20 PM
marcthib marcthib is offline
Registered User
Points: 10, Level: 1
Points: 10, Level: 1 Points: 10, Level: 1 Points: 10, Level: 1
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
Join Date: Apr 2018
Posts: 2
Thanks: 0
Thanked 0 Times in 0 Posts
Default Stop dropping CR LF TAB hidden chars when importing excel spreadsheet

Hoping someone has done this and has a nifty piece of VBA or knows how to use the Access External Data functionality that solves my issue. I have a very large Excel worksheet with several columns of data containing hidden chars TAB CR LF that must be preserved when importing to Access so the data does not display in a single line of text when end-users see it. The data will be displayed in a subform Datasheet View. I am using Access 2016. Right now Access is removing the above hidden characters during the import, it does however keep the Space hidden character intact. The Excel column data is large enough it must be loaded as Long Text. Not all columns in my spreadsheet contain the above data, just a few specific ones. Has anyone seen this and solved it? tia, Marc
Reply With Quote