locked
importing an excel csv file to excel RRS feed

  • Question

  • First off, I started by exporting to an excel sheet my accounts. I then updated that excel sheet with the new accounts and put the excel sheet into csv format. I've tried the ms-dos cvs format also and I keep getting the error: the column heading cannot be empty. As I said I exported to a excel sheet so all the fields are there. What does this error mean?

    Thank you for your time

    Friday, December 11, 2009 5:41 PM

Answers

  • Ensure you still have your header row at the top with the field names.  If you still have your header row then check your file data for any extra commas.  Open the csv file in excel and select ctrl F, enter a comma character ',' in the find box without the '' and see if you find any commas in your data.  If you find a comma, replace it with a space. 
    Best Regards, Donna
    • Marked as answer by Jim Glass Jr Monday, December 14, 2009 8:48 PM
    Friday, December 11, 2009 6:53 PM