Importing from access

[random379]

I am running excel 2007 and access 2007 on a W7 ps.
In access I have a table with 89,000 rows and 14 columns
When I try to import this into e2007, it tells me there are too many rows and only imports the first 65536.
How can I import all the rows? I thought e2007 could handle more than 1 million rows?
Thanks

[dogberry]

Hi

Check your operating system and excel if you are on 32bit you will be restricted to 65536 rows I think you will find that its the excel 64bit that handles the larger amount of data.

Good luck

Chris

[random379]

I am using the 64 bit system

[dogberry]

http://support.microsoft.com/kb/120596

In which case Im at a loss to understand either, the above link may be a work around to help you out in the short term, sorry I couldnt help further.


Chris