Re: Importing .XLS
From: Frank van Bortel <frank.van.bortel_at_gmail.com>
Date: Thu, 04 Oct 2007 19:44:19 +0200
Message-ID: <fe3di1$ike$2_at_news4.zwoll1.ov.home.nl>
Date: Thu, 04 Oct 2007 19:44:19 +0200
Message-ID: <fe3di1$ike$2_at_news4.zwoll1.ov.home.nl>
Joel wrote:
> 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?
>
Field names?!?
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