It seems odd to me (and others I've spoken with) that there aren't
more advanced import tools built into applications like Toad. Sure
you can import excel table data once you've created the table, but
isn't the tool supposed to do that for you? Are there any tools that
can take an excel file and automatically 1)determine field names,
2)determine field types, and 3) determine field lengths? Seems simple
to me!

On 3 Ott, 23:28, "johow... (AT) gmail (DOT) com" <johow... (AT) gmail (DOT) com> wrote:
Yes. There is. Do you want to know it ?

-Pam

Yes. What is the tool that you have in mind?

"Joel" <johowar1 (AT) gmail (DOT) com> schreef in bericht
news:1191492627.483999.183610 (AT) n39g2000hsh (DOT) googlegroups.com...
Let me guess... ;-)

Shakespeare

johowar1 (AT) gmail (DOT) com schrieb:
try "full convert" from "spectral core".

Volker

On 4 Ott, 12:23, "Shakespeare" <what... (AT) xs4all (DOT) nl> wrote:

You are smart Shakespeare ! ;-) Since we are not selling
consultancy services, with Robocop flying around, we need confirmation
from posters to provide them a free service.


Instructions (after install):

New Connection > Excel > Save Connection
DBExplorer > (re)Load Structure > Select the table you want > Query
Current

In the right bottom window you will see all the informations.
Example done specificly for You (do not adapt image to browser
window):
http://www.datatime.eu/public/connectedtoexcel.gif

Hints:
Quick Export will allow you to load the table into Oracle or any other
DBMS
[Quick ETL will allow to transform on the fly data while loading]

------------------------------------------------------
*free edition* download: http://www.datatime.eu/download.aspx
*free* support and questions : http://groups.google.it/group/DataTime
or write directly to me
------------------------------------------------------


"Serving Oracle Users"

-P

Nice try folks. Unfortunatly both of these tools give a default of 255
chars to text fields and a precision of 15 to numbers. Nothing
intelligent or advanced about that. I might as well use sql server to
import... Furthermore, field names aren't parsed for things like
spaces or other special characters.

Any other tools out there?

On 4 Ott, 17:41, Joel <johow... (AT) gmail (DOT) com> wrote:
No. Defaults are just a guess for large compatibility. You can / must
change the defaults.
After choosing the destination connection, click on "Table Setup".

What do you mean by " field names aren't parsed for things like spaces
or other special characters" ?
Open the "connection properties" dialog to set field appropriate
delimiters for destination fields.
The "automatic" delimiter feature is able to detect when delimiters
are needed.

For complete flexibility create a "New Data Source". Here you can
control *any* little detail of the upload including
field name and remappings for each field.

You need to get familiar with the tool. It's quite vaste.

If you feel any specific functionality is missing please just describe
it providing appropriate details and we will
add it on the fly for the Oracle Community.

-P

"pamela fluente" <pamelafluente (AT) libero (DOT) it> wrote


Thank you, Pam, but a little discretion, por favore.

Joel wrote:
Since when does a spreadsheet have field names?

I am guessing here: column headers?

Oracle has the answer: you save a CSV and define
an external table

--
Regards,
Frank van Bortel

Top-posting is one way to shut me up...