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
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