I think the title says most of it.
How do I, in MS Access using VBA, get information from a workbook which I can then put in as a recordset in a table?
I know that excel has an easy workaround for other excel workbooks, and I've read somewhere how to get recordsets from access and input them to excel
Excel to excel:
Dim wb As Workbook Dim path As String path = "D:\Documents\etc\Book1.xls" Application.ScreenUpdating = False Set wb = Workbooks.Open(Path, True, True) With wb 'do stuff here End With wb.Close False Set wb = Nothing