Help, Unable to add Records into Database

[zeezee]

ConnectionData_Cust.Open = ("Select * FROM CUSTOMER")

I think this is wrong.
open method requires a connection string as a parameter.
to use a SELECT querry, first you have to open the connection to the database.
Then use Connection.Execute, to execute any SQL querry (or any DB commands)

it should be just ConnectionData_Cust.Open

As for the Type mismatch, you are using a ADODB connection to populate a DAO recordset.
ADODB connection returns a ADODB record set. change the Recordset type or connection type