Before writing a lot of MFC software, to be able to Access data in the database export to Excel file, but did not consider the problem of large amount of data, now many clients are gradually reflects the problems of the software will not export data, for the great god,

CodePudding user response:

EXCEL seem to have rows and columns most biggest limit
Excel2003 version of the maximum number of lines is 65536 lines, Excel2007 began the version of the maximum number of lines is 1048576 lines, the maximum number of columns Excel2003 is 256, more than 2007 version is 16384 columns,

Upgrade Office version or over a certain number of rows/columns to add new Sheet or a new file

CodePudding user response:

Because of my DATABASE columns have 213 columns, in strcommand) Format (_T (" SELECT * into [Excel; 5.0 HDR=YES; DATABASE=% s], [sheet1] from % s "), path, VIEW_DATA); Function operation, the amount of data rows over 10000 will prompt "data table", if the individual field data read and write Excel file will be slow,

CodePudding user response:

I used to use directly access or excel vba in dealing with these things, you can try, you don't mind feel something office family cohesion is very good

CodePudding user response:

Through. CSV format file transfer?

CodePudding user response:

Can be exported to more than one file