Today I got a question regarding importing via the CRM Import tool (Menubar -> Tools -> Import). Only a small number of records would import, all the others would not. Even though the source seemed fine, they did throw this error:0x80040328: Number of columns does not match the header rowThis appears to be related to the source anyway. When you save an file in Excel 2003 as csv, it does the
Showing posts with label excel. Show all posts
Showing posts with label excel. Show all posts
Friday, 16 February 2007
Monday, 20 November 2006
Maximum amount of records in Excel export
Posted on 06:36 by Unknown
I'm very busy at the moment (just like you all probably), so just a small post. The default for the Excel export is a maximum of 10.000 records. If you need to export more, then you'd need to modify a registery setting. Follow the next steps to achieve this:- Start Regedit- Navigate to HKLMachine\Software\Microsoft\MSCRM- Create a new DWORD value named 'maxrecordsforexporttoexcel'- Give the new
Subscribe to:
Posts (Atom)