problem with importing data into excel from oracle
I am trying to import the data from oracle into and excel sheet using copyfromrecordset and thereafter import this excel file into my datatable. The basic purpose behind this is to quicken the process of reading the data. If i loop through the recordset and import the data directly into datatable, it takes a very long time and my test application session ends.
The problem is, when i try to import the excel file, it throws an Invalid File error. I am using excel2007 on my machine. If i save it as .xlsx file then MicExcel is able to open up the file without any hassle whereas when i save it as .xls file, it pops up format/compatibility error.
I have been trying to find out the solution for past 3 days but am not able to do so. Maybe its an error in my scripting itself somewhere i dont know, because everything looks perfectly fine to me. Please help me out with this guys.
Re: problem with importing data into excel from oracle
I am facing a similar issue with exporting the data from oracle to excel, please could you tell me what exactly you are doing, so that may be incase i find a solution, i could let you knw