Yes, you can use VBA to pass  values into Access. Depending on your needs
you can opt to link or import spreadsheets from within Access as well.
When using VBA you will require reference to Microsoft's Access Library,
and understand that Access refers to tables as "recordsets".