Forum Discussion
Marsha_R
Champion Level 3
As you can see, Excel doesn't always play well with others.
Are you copying from the database to Excel in order to use the data for testing? I would use a .csv file instead of Excel. There's no hidden functionality to worry about then. Your data is just there.
Archana_72
6 years agoContributor
Hi,
I have even tried out in csv and had same problem.
recordset is getting cleared once we start accessing/ looping through data.
- Marsha_R6 years agoChampion Level 3
Where exactly in the code do you see that that recordset is gone? Does it happen after once through the loop or some other time?
Are you sure that the recordset is even there in the first place? Have you tried outputting the values to make sure?
Related Content
- 10 years agoAlice
Recent Discussions
- 5 hours agojstaehlin
- 23 hours agoAivanitskiy