MS Office Forum

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds

Exporting data from Excel

  Asked By: Keana    Date: Mar 16    Category: MS Office    Views: 1812

I want to import data from Excel file to Oracle using oledbDataReader.
But I want to do it column wise rather than row wise. Can any one help me out
for this.



5 Answers Found

Answer #1    Answered By: Sage Anderson     Answered On: Mar 16

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.)

Answer #2    Answered By: Khadeeja Malik     Answered On: Mar 16

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.

Answer #3    Answered By: Shayan Anderson     Answered On: Mar 16

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.

Answer #4    Answered By: Daniel Costa     Answered On: Mar 16

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?

Answer #5    Answered By: Grace Ellis     Answered On: Mar 16

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

Didn't find what you were looking for? Find more on Exporting data from Excel Or get search suggestion and latest updates.