 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / Importing / Linking / July 2005Exporting more than 65K records to Excel
I want to export a large amount of data to Excel, but the standard export utility in Access will only let me export 65K at a time. How do I do a full export of a large table without having to split the data up into separate exports? AFAIK you can't. It's not Access, it's Excel actually which imposes this restriction: 65,636 is the maximum number of rows in an Excel sheet. Split and export to several sheets within the same workbook is the best you can do. HTH, Nikos Darren, As Nikos pointed out, it's a limitation of Excel not Access. May I ask why you need to export such large amount of data to Excel? I can't think of anything that you can do in Excel and can not do in Access. As a matter of fact, the scenario is usually the reverse. You export FROM Excel TO Access because of Excel's limitation (i.e. capacity is a common one). Not the other way around. Still, if you can establish a legitimate reason why you need to export all that data then you can export to a text file. A text file will go beyond 65k records. HTH, Immanuel Sibero > I want to export a large amount of data to Excel, but the standard export > utility in Access will only let me export 65K at a time. How do I do a full > export of a large table without having to split the data up into separate > exports? I need to import the data from Access to Oracle. > Darren, > [quoted text clipped - 18 lines] > > export of a large table without having to split the data up into separate > > exports? Hi Darren, Try exporting to the text file format. Oracle can read text file (CSV). Actually, I have not had the opportunity to work with Oracle but surely it can read text file. Immanuel Sibero > I need to import the data from Access to Oracle. > [quoted text clipped - 20 lines] > > > export of a large table without having to split the data up into separate > > > exports? |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.