Creating columns in a table using column header

[Viswa Sethu]

Hi,

We have a comma separated data file with more than 40000 records and 80 columns.
The requirement is to load all these records in to a an existing table, which has part of these 80 columns(35 columns are already present).So while loading this file rest of the 45 columns are to be created on the fly.Is it possibel to do this using sql loader or anyother method available.I think MSAccess supports such feature, does oracle have any option for this?I have the list of column names as the column header as the first row in the file.

Please suggest.

Thanks
Viswa

[Jeanne Boyarsky]

Viswa,
As far as I know, you need to create the columns (via DDL) before doing an import.