Re: Importing .XLS
Date: Thu, 04 Oct 2007 19:44:19 +0200
> 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?
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...Received on Thu Oct 04 2007 - 19:44:19 CEST