I have a huge Excel workbook application containing lots of data that can actually go into a database.

I was thinking of making an Access Database with a few tables that can hold such data, transfer the data to the database tables and then whenever data is needed go and read it from the database instead of finding it in the different worksheets.

It's Excel 64Bit with VBA that must access the database.

Any pointers to a good reference that can give me an example of what needs to be referenced in VBA, how to create the connection, how to create a recordset etc.

I have no experience with accessing a database from VBA code.