Import Spreadsheet to Customer Table from a form and dialog box

[duffy180788]

hi guys,

I want to transfer data from a excel spread sheet to an access database, I want create a button saying import customers, a box opens up you select the file.

the excel file is going to always be the same layout,
example ( Name , DOB )

to accces database : Customers

Field, (Name , DOB )

I want to keep the formats ect, can anybody point me in a direction please?

thankyou

craig