PB6.5 using ole import 10000 records times out of memory error (memory has been in consumption, but did not run out), checked a lot of people met, but no actual solutions

Which master knows help, hurry to have quests,

The PC configuration: Windows 7/4 gb of memory

CodePudding user response:

The data source is what?

CodePudding user response:

A excel file, 1000 lines, 3 columns, there are five fields since the data window, the other two is set automatically by the program default values,
So there is no use of DW's own function, it is read out processing one grid,

CodePudding user response:

Partial import is wrong, is ten thousand lines, also not line, Memory consumption, consumption Of about 30 m or so Out Of the Memory, is there any way to release Memory when partial import guide afresh after

[09:55:47] [superadm] ll_usedRow: 10001, ll_usedCol: 3
[09:55:47] [superadm] began to check the import of the legitimacy of the Excel file
[09:55:58] [superadm] check the legitimacy of the import file data success: 1000
[09:55:58] [superadm] ll_usedRow: 10001, ll_usedCol: 3
[09:55:58] [superadm] began to check the import of the legitimacy of the Excel file
[09:56:09] [superadm] check the legitimacy of the import file data success: 2000
[09:56:10] [superadm] ll_usedRow: 10001, ll_usedCol: 3
[09:56:10] [superadm] began to check the import of the legitimacy of the Excel file
[09:56:22] [superadm] check the legitimacy of the import file data success: 3000
[09:56:23] [superadm] ll_usedRow: 10001, ll_usedCol: 3
[09:56:23] [superadm] began to check the import of the legitimacy of the Excel file
[09:56:36] [superadm] check the legitimacy of the import file data success: 4000
[09:56:37] [superadm] ll_usedRow: 10001, ll_usedCol: 3
[09:56:37] [superadm] began to check the import of the legitimacy of the Excel file
[09:56:50] [superadm] check the legitimacy of the import file data success: 5000
[09:56:50] [superadm] ll_usedRow: 10001, ll_usedCol: 3
[09:56:50] [superadm] began to check the import of the legitimacy of the Excel file
[09:57:03] [superadm] check the legitimacy of the import file data success: 6000
[09:57:03] [superadm] ll_usedRow: 10001, ll_usedCol: 3
[09:57:04] [superadm] began to check the import of the legitimacy of the Excel file
[09:57:20] [superadm] check the legitimacy of the import file data success: 7000
[09:57:20] [superadm] ll_usedRow: 10001, ll_usedCol: 3
[09:57:20] [superadm] began to check the import of the legitimacy of the Excel file

CodePudding user response:

refer to the second floor u010838085 response:

is an excel file, 1000 lines, 3 columns, there are five fields since the data window, the other two is set automatically by the program default values,
So there is no use of DW's own function, it is read out processing one grid,

Don't be so, is too slow, can all, and then copied to the clipboard, and then use dw_1. ImportClipboard (), can guide in all the data directly, so that should not make a mistake

CodePudding user response:

Can't use dwcontrol. ImportFile?

CodePudding user response:

Gs_tran ls_tran

GetFileOpenName (" Select File ", FilePath, FileName, "*. *", "EXCEL File (*. XLS; *. XLSX), *. XLS; *. XLSX, "GetCurrentDirectory (), 18)


Ls_tran=Create gs_tran

Ls_tran. DBMS="OLE DB"
Ls_tran. The AutoCommit=False
Ls_tran. DBParm="PROVIDER='12.0' Microsoft. ACE. The OLEDB., DATASOURCE='" + filepath +"', PROVIDERSTRING='12.0' Excel; HDR=YES; IMEX=1; MAXSCANROWS=1280;"

Connect using ls_tran;

Ls_error=ls_tran. Sqlerrtext

Ls_sql='select * from [sheet1 $]'

Ls_syntax=ls_tran. Syntaxfromsql (ls_sql, ' ', ls_error)

Dw_temp. Create (ls_syntax)

Dw_temp. Settrans (ls_tran)

Ll_row=dw_temp. Retrieve ()

Disconnect the using ls_tran;

Destroy ls_tran


Try this one, to create a dw, and then read from the inside

CodePudding user response:

reference 5 floor lzp_lrp reply:

Quote: refer to the second floor u010838085 response:

A excel file, 1000 lines, 3 columns, there are five fields since the data window, the other two is set automatically by the program default values,
So there is no use of DW's own function, it is read out processing one grid,

Don't be so, is too slow, can all, and then copied to the clipboard, and then use dw_1. ImportClipboard (), can guide in all the data directly, so that should not make a mistake

Use this function to IMPORT, but the file more than DW field length will prompt: "item validation error on IMPORT, the continue IMPOR", in order to avoid this problem is to read a line judge data validity

CodePudding user response:

refer to the eighth floor u010838085 response:

Quote: refer to the fifth floor lzp_lrp reply:

Quote: refer to the second floor u010838085 response:

A excel file, 1000 lines, 3 columns, there are five fields since the data window, the other two is set automatically by the program default values,
So there is no use of DW's own function, it is read out processing one grid,

Don't be so, is too slow, can all, and then copied to the clipboard, and then use dw_1. ImportClipboard (), can guide in all the data directly, so that should not make a mistake

Use this function to IMPORT, but the file more than DW field length will prompt: "item validation error on IMPORT, the continue IMPOR", in order to avoid this problem is to read a line judge data validity

You adjust the fields in the data window length longer (can be modified by the editsource a length), each field of lane 2000, import after check again, if no problem, then save

CodePudding user response:

Do an external data source dw, format and excel, and then importfile to the dw, and then think how