How many rows are you working with? Are you saying that the format of
your Excel file  is not setup so that the first row  are your labels and
second row through however many are your records you want imported?

That your labels are all in column  A and the data  is in columns B
through IV? IF so, you may want to look at the Transpose feature of a
copy and Paste Special. (Select your labels and data, copy it, move to
a new sheet or book, from the Edit menu, select Paste Special, and then
place a checkmark in Transpose. The labels and data will be rotated.)

But I am importing this through Vb.Net DLL and I cannot afford to copy
the data  into a new sheet and then import. Is there any other way for this or
any work around.

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.

To clarify. I have a customized column  of numbers that have leading
zeros in an Excel worksheet. It is a very long column. When these
numbers are exported to Access the column loses the leading zeros.
Yes, I know how to manually make a table of numbers in Access using
the data-type text to have a field (column) that has leading zeros. In
addition, I can create the column I need in seconds in Excel so why
spend a long time manually entering in Access?

As someone has aleady sugested, keep them in access as numbers and use a
format in Access to force the trailing zeros.