exporting from access to excel gives error about file limits

Kyle775

Board Regular
Joined
Feb 16, 2005
Messages
230
when i use the "office links: analyze with microsoft excel" option in access it returns an error about too many rows to export? but its less than 30,000??
i have no idea why this would happen, its less than 10 columns and about 29,000 odd rows?? its not a query or anything like that... its just a table i want to analyze with excel?? i was planning on doing more analytics this way but with a much higher row count... im just testing the limits of both applications right now.... is there some information i should know? in my reading ive found that excel is 65000 odd rows and access tables are only limited by disk size 2gb or something like that... so the row number is relative to how much data is in each row... anyway.... any help would be great... we are nearing year end and i would like to be able to simplfy some things.... using access instead of 10 worksheets :)

thanks
 

Excel Facts

What is the last column in Excel?
Excel columns run from A to Z, AA to AZ, AAA to XFD. The last column is XFD.

BrianB

Well-known Member
Joined
Feb 17, 2003
Messages
8,127
Strangely I have never used this feature despite may years experience. I would guess that it is a problem with the "analysis" feature.

As you say, it is a relatively small table. Why not do as I usually do and simply import the table into Excel (or export the table to a worksheet) and use Pivot Tables etc.
 

Kyle775

Board Regular
Joined
Feb 16, 2005
Messages
230
the problem is im planning on using much larger sets of data, 100,000 rows etc. and i would like the sheets to be updated as the access database is changed. i guess i will have to simplify the data as queries and either link to those or export them. my real problem is that no one here knows access and they all want to use excel....

thanks for your help!
 

BrianB

Well-known Member
Joined
Feb 17, 2003
Messages
8,127
Excel will only take 65,536 rows max
I suggest you link a pivot table to your Access table via Data/Pivot Table Report/Get External data
 
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

Forum statistics

Threads
1,164,004
Messages
5,834,833
Members
430,324
Latest member
bosphoruskid

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top