I'm confused as to what exactly the problem is.



What limitations are you working with?



There are a number of different ways to export data  from an excel
spreadsheet but unless we know more, any attempt to assist with your
specific case is just a shot in the dark. If you could provide a more
detailed explanation, someone here will probably be able to assist you.
Start with what format the data needs to be in to accomplish your task.
Do you want to feed Oracle a data array (thus avoiding creation of a new
file)? Do you want to feed the data one column  at a time (consider a
delimited string of text)? Do you need headers? Is this an actual data
file or a transfer of data from a form? Why can't you create an
external file  using the Save As features built into the Windows
operating system (this is the most efficient way I've found to transfer
large quantities of data when using vb)?



The more info you provide the better the answer you will receive.