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>


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

Original text of this message