Preparing data to insert into SQL table

[godonnygo]

I've got an excel spreadsheet full of data that I want to insert using SQL into an Oracle database.

The data is separated into columns. The columns are ID, Name, ***, DOB, Address, Phone.

I want to be able to get this data to fall into the following statement:
insert into TABLE
values (0001,'Robert Harvey','M',18/01/1971,'8 Heversham Grove', 'Melton',96816487);

There are around 900 records with the data laid out similar to the above fashion. How would I get all these values into individual insert statements?

[mrice]

Try somethng like

Please Login or Register  to view this content.

[godonnygo]

Cheers for that,

what's the DB access code though?

[mrice]

Have a look at