Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations John Tel on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Pivot table slow reading records - ODBC text driver

Status
Not open for further replies.
bojzon

bojzon

IS-IT--Management
Sep 18, 2003
25
SI
WinXP, off2003, PC RAM 2 Gb, procesor 3,8 GHz
Problem:
I should (VBA sub)create xls pivot table report from txt file with 150.000 recors or more. I used ODBC text driver connection and first 56.000 recors are reading normaly, but others 100.000 with speed about 60 records per second. (the same speed with mdb files and access driver).
Is any possibility to speed up pivot table reading records.
(no success with changing MaxBufferSize,MaxScanRows,...)
Need explain about parameters MaxBufferSize,MaxScanRows, PageTimeout.

Thanks
Bojzon
 
Status
Not open for further replies.

Similar threads

M
  • Locked
  • Question
Reference Pivot Tables by name 1
Replies
2
Views
814
mintjulep
M
Andrzejek
  • Locked
  • Question
Outlook Template replace text 2
Replies
13
Views
2K
Andrzejek
Andrzejek
arvarr
  • Locked
  • Question
Variable in Pivot Table 1
Replies
4
Views
364
arvarr
arvarr
linuxguyEastCoast
  • Locked
  • Question
export text from non-public docx, pptx, pdf
Replies
0
Views
497
linuxguyEastCoast
linuxguyEastCoast
arvarr
  • Locked
  • Question
Pivot Table drill through in a new workbook
Replies
3
Views
491
arvarr
arvarr

Part and Inventory Search

Sponsor

Back
Top