Hi
My work email address has recently changed. The old email address still routes through to me, but emails from me now come from the new address. That means I’ve had to subscribe under my new email address, and have no way of unsubscribing my old email address. However, two copies of every post are coming through to me.
How do I get this fixed?
Mike
Dear TOADies,
I am trying to import xlsx file into an oracle table (using TOAD’s “Import Table” feature"), but TOAD does not recognize fields and does not offer me an option to link table columns to spreadsheet columns. If I save the file as an old Excel (xls) it works fine.
The version of TOAD is 10.6.1.3
Is it a known issue?
George
I am not on version 10 like you, I’m on 9.1 and I know that .xlsx files
(EXCEL 2007 format) is not supported
On Mon, Feb 7, 2011 at 3:39 PM, wrote:
Dear TOADies,
I am trying to import xlsx file into an oracle table (using TOAD's
"Import Table" feature"), but TOAD does not recognize fields
and does not offer me an option to link table columns to spreadsheet
columns. If I save the file as an old Excel (xls) it works fine.
The version of TOAD is 10.6.1.3
Is it a known issue?
GeorgeLater versions of 9, such as my 9.7.2.5, do support it, though I have to select
“All Files” before they show up.
Even so, I have not experienced George’s troubles. Whew!!
Dan
Daniel B Madvig
Computer Technologies
Northwestern College & Northwestern Media
3003 Snelling Ave.
St. Paul, MN 55113
www.nwc.edu
651.631.5323
Hi George,
This works fine for me. Did you set the “First row” field to 2?
That’s the trigger for the ‘map’ dialog.
-John
Yes, I set up the first row field to “2”.
Hm. Well, I’m not sure what’s going on. If you send me the file and
table DDL I’ll be happy to try it…