By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
444,152 Members | 2,576 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 444,152 IT Pros & Developers. It's quick & easy.

Exporting Data from MS Access to Excel

P: 11
Hi,

I am trying to Export rows greater than 65K (appproximately 500K records) from MS Access to MS Excel. Whenever I do that, the records only populate up the max value for 1 sheet in Excel and leaves off the rest. How can I tell Excel to make sure that when it completely populates the number of rows in Sheet1 of Excel, to move to the next sheet?

This should be pretty basic, but I can't figure it out. Thanks!
Aug 30 '07 #1
Share this Question
Share on Google+
2 Replies


JConsulting
Expert 100+
P: 603
Hi,

I am trying to Export rows greater than 65K (appproximately 500K records) from MS Access to MS Excel. Whenever I do that, the records only populate up the max value for 1 sheet in Excel and leaves off the rest. How can I tell Excel to make sure that when it completely populates the number of rows in Sheet1 of Excel, to move to the next sheet?

This should be pretty basic, but I can't figure it out. Thanks!
I noticed this posting on "another" site. Have you found your answer?
J
Sep 1 '07 #2

FishVal
Expert 2.5K+
P: 2,653
Hi, there.

Take a look at this thread
Exporting huge records to Excel from Access
Sep 1 '07 #3

Post your reply

Sign in to post your reply or Sign up for a free account.