Hi all,
I'm trying to copy data from Excel to Access, by using VBA in Excel. All I have in Access is a table, and I want to use Excel to copy it's data from a sheet to a table in Access. (specifying which cell goes to which tablename/columnname in access).
I see alot of examples for the opposite thing (access to excel). Any help with how to do it the other way round , Excel to Access, through Excel VBA?
Many thanks.
t.