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
 

Some videos you may like

Excel Facts

Can a formula spear through sheets?
Use =SUM(January:December!E7) to sum E7 on all of the sheets from January through December

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
 

Watch MrExcel Video

Forum statistics

Threads
1,118,388
Messages
5,571,847
Members
412,420
Latest member
grace_abar
Top