Toad World® Forums

List maintenance issues


#1

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


#2

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


#3

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?

George

#4

Later 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
image001.jpeg


#5

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


#6

Yes, I set up the first row field to “2”.
image001.jpeg


#7

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…