I've got two issues. 1) I want to export data to Excel 2007/2010 using copyRecordset method. It works fine for non filtered recordset,but for a filtered recordset it just ignores the filter and dumps all the record on to the excel sheet. I've not been able to find a solution to that on the net
2) So, I am doing the hardway. Which is populating each cell one at a time! Works fine mostly(although pretty slow) except that it(Excel) is unnecessarily formatting the data. For example, if data is like 'Sep1', it formats it into 1 sept. What's the syntax for preformatting the cell. May be if preformat the cell like general or text type, it won't format the actual data? suggestions?Thanks
2) So, I am doing the hardway. Which is populating each cell one at a time! Works fine mostly(although pretty slow) except that it(Excel) is unnecessarily formatting the data. For example, if data is like 'Sep1', it formats it into 1 sept. What's the syntax for preformatting the cell. May be if preformat the cell like general or text type, it won't format the actual data? suggestions?Thanks
