 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / Importing / Linking / September 2004Analyze w/ Excel
I tried to analyze my Table with excel. The table has only 28k rows, but it will not let me put it out on excel... Why? I believe that Analyze with EXCEL uses EXCEL 95 structure, which is limited to 16000 (approximately) rows.  SignatureKen Snell <MS ACCESS MVP> > I tried to analyze my Table with excel. > > The table has only 28k rows, but it will not let me put it > out on excel... > > Why? >-----Original Message----- >I believe that Analyze with EXCEL uses EXCEL 95 structure, which is limited >to 16000 (approximately) rows. Correct. If you need to copy 16,000 - 65,500 records into Excel, your best bet is to either manually copy/paste into a worksheet or do a TransferText to a new text file, then import the text file into Excel. You can open a virtual copy of Excel from Access to do the latter in VBA. HTH, TransferSpreadsheet allows use of EXCEL 97 and higher versions, which allow 65536 records to be exported to a spreadsheet. > >-----Original Message----- > >I believe that Analyze with EXCEL uses EXCEL 95 [quoted text clipped - 10 lines] > > HTH, Try an export of the table/query to Excel and clear the check box for "formatting", instead of the "Analyze it with Excel" method. > I tried to analyze my Table with excel. > > The table has only 28k rows, but it will not let me put it > out on excel... > > Why? |
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.