Import more than 60 ten thousand EXCEL record, each time to 10 tens of thousands of records, pb11.5-CodePudding

Import more than 60 ten thousand EXCEL record, each time to 10 tens of thousands of records, pb11.5 error, is that under Windows, the program mistakes in a prompt, point to cancel automatically shut down after the has greatly met?

CodePudding user response:

refer to the original poster shinesky response:

import more than 60 ten thousand EXCEL record, each time to 10 tens of thousands of records, pb11.5 error, is that under Windows, the program mistakes in a prompt, point to cancel automatically shut down after the has greatly met?

Article 60 times import, an import 10000, and then save, and then import under article ten thousand

CodePudding user response:

If it's just one-time import or by the moderator speak, segmented import, import after submission, data volume is too big, may not be your PB program error, but out of memory or temporary database space is not enough,

CodePudding user response:

The Excel record save as a text document, reoccupy import data window, more than 60 ten thousand one-time import should be no problem,

CodePudding user response:

3/f method can, I tried,

Can also be copied to the system clipboard, and then copy the data window above, and then in the update, is also a way to test pass

CodePudding user response:

You stupid ah, don't separate guide?

CodePudding user response:

Separate import, or don't save as CVS import again

CodePudding user response:

reference 4 floor h_flys response:

method can 3 floor, I tried,

Can also be copied to the system clipboard, and then copy the data window above, and then in the update, is also a way to test by

The method is good, province cycle

CodePudding user response:

reference 4 floor h_flys response:

method can 3 floor, I tried,

Can also be copied to the system clipboard, and then copy the data window above, and then in the update, is also a way to test by

Method can 3 buildings, but 600000 one-time import data, no, it is suggested that into several files import

Can also be copied to the system clipboard, and then copy the data window above, and then in the update, is also a way to test by
This method is feasible, but article 600000 data, have you ever tried? Is the method to estimate the original poster with, appear problem, can divide second import, 10000 at a time

CodePudding user response:

Using dotnet import

CodePudding user response:

Did the setredraw attribute is set to not be impact