title: MS Access VBA - Importing CSV Files - Upside-down "L"
body: <p>I have a macro in Access which for all the files in a folder reformats and imports the data into Access tables. For most of these file it works perfectly, however for some it does not import anything. I have debugged the process and found that when these files are pulled into the recordset I have created to hold them as I reformat every character is broken up with an upsidedown "L":</p>
  
  <p><img src="https://i.stack.imgur.com/PXlGo.png" alt="ScreenShot.png"></p>
  
  <p>This is not in the file, not can I see it in any other view. If I set a watch on a variable and fill it with this string it interprets it as a space. Also these are not visible in the file if I open it in Excel or notepad...</p>
  
  <p>Any idea what is causing this?</p>
  
  <p><a href="https://docs.google.com/spreadsheets/d/1VgDiw5VqWtuFFtI3FJYBJkwsV3FB6c7DoL5ZdgDb05E/edit?usp=sharing" rel="nofollow noreferrer">Link to example file on Google Drive</a></p>