Import csv error when select 1st row as header RRS feed

  • Question

  • I am getting the error "an error occurred while loading the file" only after I select the "Use first row as column headers" option. Any ideas? I've tried changing the file type to excel, changing the location of the file, reruning the SAS program that generated the file, and restarting my computer. Please help me...

    Monday, February 5, 2018 10:39 PM


All replies

  • Hi paleta2003,

    Thanks for your question.

    Please follow below steps to import CSV(note:I only test it in EXCEL 2016).
    1) go to "Data--New Query--From File--From CSV"

    2) find the CSV file, click on Import, select "Edit"

    3) In the Query Editor window, select "Use First Row as Headers", then click on "Close & Load".

    Best Regards
    Willson Yuan
    MSDN Community Support
    Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact

    Tuesday, February 6, 2018 6:22 AM
  • Does your header row have any special characters or other language characters? May be you can try opening it in Notepad++ to see if it contains any invisible characters if you cant find it visibly

    Please Mark This As Answer if it solved your issue
    Please Vote This As Helpful if it helps to solve your issue
    My Wiki User Page
    My MSDN Page
    My Personal Blog
    My Facebook Page

    Tuesday, February 6, 2018 6:26 AM