10-22-2009 07:28 AM
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.
10-22-2009 07:52 AM
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.
10-22-2009 08:36 AM
Gosh that is GREAT to know! My love for you is totally inappropriate! LOL!!!
Discover and save your favorite ideas. Come back to expert answers, step-by-step guides, recent topics, and more.
New here? Get started with these tips. How to use Community New member guide