Re: $$Excel-Macros$$ Need exporting help for Records more than 65000 records in Access to Excel

2013-02-07 Thread Utpal Samui
I think u are using Excel 2003 or lower version in which max. row no. is 65536. So, Try with Excel 2007 or Higher version.. Regards, utpal On Sun, Feb 3, 2013 at 3:16 PM, rekha siri rekha.siri2...@gmail.com wrote: hi Group, Need your expertise help i along with my friends uploaded some

Re: $$Excel-Macros$$ Need exporting help for Records more than 65000 records in Access to Excel

2013-02-07 Thread Swapnil Palande
Hi, Usr adodb recordset object and sql query to retrive data. And use copyfromrecordset method to add data in excel. Regards, Swapnil On Feb 3, 2013 3:17 PM, rekha siri rekha.siri2...@gmail.com wrote: hi Group, Need your expertise help i along with my friends uploaded some excel file into

$$Excel-Macros$$ Need exporting help for Records more than 65000 records in Access to Excel

2013-02-03 Thread rekha siri
hi Group, Need your expertise help i along with my friends uploaded some excel file into Access . Now the Access is having around 1lac records . Need help in exporting from access to excel all the 1lac records. i tried exporting it to excel from access but it is throughing only 65000 records.