aman729_88
asked on
problem: memory leak by adodb connection
hi,
i am using adodb connection to read a cell from excel once in every 500ms using timer
and i am not able to free memory and also the application hangs,
i want to know will the data export to ms sql server 2005 and then reading it from there will help..
or it will become more slow.
how can i export excel data to sql server 2005?
thanks!
i am using adodb connection to read a cell from excel once in every 500ms using timer
and i am not able to free memory and also the application hangs,
i want to know will the data export to ms sql server 2005 and then reading it from there will help..
or it will become more slow.
how can i export excel data to sql server 2005?
thanks!
Last Comment
ASKER
you can see the code in the following link
https://www.experts-exchange.com/questions/23149947/linking-excel-cell-to-vb6-form-tetxbox.html
https://www.experts-exchange.com/questions/23149947/linking-excel-cell-to-vb6-form-tetxbox.html
ASKER
i am using ms excel 2003
ASKER CERTIFIED SOLUTION
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER
i did that but i am getting an error 'either BOF or EOF is true, or the current record has been deleted. requested operation requires a current record'
how many times are you calling this sub? once in the whole program?
ASKER
thankls
Microsoft Excel
Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.
144K
Questions
--
Followers
--
Top Experts
Get a personalized solution from industry experts
TRUSTED BY
also you can save your excel file as CSV and import from sql 2005 manager
your data must be well formatted to do this
but maybe we can find this memory leak, what version of excel are you using?
and what is your code to import the adobd data?