Query Tables (excel odbc) memory problem

G

Gregory

I discover that when i recounting more then 200 QT on one sheet with this
simply code



Set qt_data = result_sheet.QueryTables.Add("ODBC;DSN=Excel Files;DBQ=" +
ActiveWorkbook.Name + ";DefaultDir=" + ActiveWorkbook.Path +
";DriverId=790;MaxBufferSize=2048;PageTimeout=5;",
result_sheet.range("AA1"), sql_str)

With qt_data
.PreserveFormatting = True
.FieldNames = False
.BackgroundQuery = False
.AdjustColumnWidth = False
.RefreshStyle = xlOverwriteCells
.Refresh
End With
qt_data.Delete



my EXCEL.exe process (2003 ver.) becomes very slow, "hard" (~300-400 Mb) and
"unstoppable" (closing frames, but not unload process)

Can you give me any advice?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel ODBC query tables memory overflow 9
Unwanted Querytable Autofilter on ODBC Import 4
General ODBC Error 0
Refresh Excel Sheet with Access Data Frequently 0
Data connection between Excel sheets 0
VBA Import from Access using ODBC - then trying to manipulate some columns; import comes after 2
HELP JOEL: auto populate certain userform fields from access datab 0
Not able to declare variable in MS Query. 2

Top