Re: Importing .XLS

From: Frank van Bortel <>
Date: Thu, 04 Oct 2007 19:44:19 +0200
Message-ID: <fe3di1$ike$>

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

Frank van Bortel

Top-posting is one way to shut me up...
Received on Thu Oct 04 2007 - 19:44:19 CEST

Original text of this message