RE: Re: Textfile into oracle

2002-06-06 Thread John . Hallas
Roland, If you are saying that you have 100 columns in the spreadsheet but you only want to copy 9 columns into a table with 9 fields then you have 2 choices. Reduce the spreadsheet to only 9 columns (by copying to another worksheet) and then saving as a CSV file and importing by sqlloader. I

RE: Re: Textfile into oracle

2002-06-06 Thread Mark Leith
Roland, At the risk of being the extremo de la broma to the OT lot. The field names that you have specified in the excel file will need to be deleted anyway. You will need a control file that loads the data in to a table that has a hundred (100) fields. You will then need to save the excel file