I have an Excel template with a range called data_range. I want to create an
Excel macro that exports this range to a table called Data in an Access db
called contract amendment log.mdb
I'm stuck.
I can work out how to import the data using Access but most of my users
don't have Access so I want them to use Excel and export the data across our
network.
Each Excel file is created from a template so the name is not fixed.
Can anyone help me?
Thanks and regards,
Shep