Open Dbase file

[Excelboo2]

I have a dbase file which has data exceeding the maximum the no. of row of 65536 per page in excel. So how can I open it in a way that excel can split it into pages? Thanks

 

[Clay Canvas]

Data import into multiple sheets

The link below may help...

http://www.mrexcel.com/board2/viewtopic.php?t=262779&highlight=

 

[NateO]

Hello,

Here's how I would do it:

http://www.utteraccess.com/forums/showthreaded.php?Number=1146152

Except I'd modify it, slightly, to pull instead of push, if that's the requirement.