Preparing data to insert into SQL table

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?

Try somethng like

Sub Test()
For N = 2 To Cells(65526, 1).End(xlUp).Row
    MySQLSTring = "insert into TABLE values (" & _
    Cells(N, 1) & ",'" & _
    Cells(N, 2) & "','" & _
    Cells(N, 3) & "'," & _
    Cells(N, 4) & ",'" & _
    Cells(N, 5) & "', '" & _
    Cells(N, 6) & "'," & _
    Cells(N, 7) & ");"

    'Insert your DB access code here

Next N
End Sub

Cheers for that,

what's the DB access code though?

Have a look at

HTML Code: