DCR Export utility and excel07

Unanswered Question
Oct 22nd, 2009

Is anyone having difficulty with DCR Export utility and MS Excel 2007? I am unable to use .csv files converted from 2007 Excel; this wasn't a problem before. When I import the csv file DCR comes back saying the Header information is missing.

I have this problem too.
0 votes
  • 1
  • 2
  • 3
  • 4
  • 5
Overall Rating: 0 (0 ratings)
Joe Clarke Thu, 10/22/2009 - 07:52

Yes, this is because Excel 2007 changed how it handles CSV files. We currently have en enhancement request filed to handle what it does to files (CSCsz39156). The workaround is simple. Edit the CSV file in notepad, and remove the lines at the top with are all commas (I believe there will be two). Then the file will import just fine.

kathegaj2 Thu, 10/22/2009 - 08:36

Gosh that is GREAT to know! My love for you is totally inappropriate! LOL!!!


This Discussion