MS suggests a macro:

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

--
Jim
"Yana D" <Yana wrote in message
...
|I have a user who needs to import 95000 rows and can not utilize anything
but
| Excel. Is there a way to do it? One of the posts answers mentioned
| distributing data into different worksheets. How do you do it?