Exporting data range from Excel to Access

[Guest]

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

 

[Ron de Bruin]

Hi Shep

See this page
http://www.erlandsendata.no/english/index.php?t=envbadac

 

[Guest]

That's perfect. Thanks so much Ron.

Shep

Hi Shep

See this page
http://www.erlandsendata.no/english/index.php?t=envbadac

 

[Guest]

See this page
http://www.erlandsendata.no/english/index.php?t=envbadac

Ron,

I have successfully used the code found at this page to upload info from
Excel to Access.

However my needs are a bit more advanced. I need a method to control the
upload - either to make the upload only happen once when pressed, or else to
find the data in access and overwrite it.

Currently when you press the button multiple times, the information is
continually appended. I'm developing a timesheet system and want employees to
upload time to the database one a month, and I need an internal control for
that. I may even need the ability for them to edit the data.

Can anyone help with this request? It seems to be an advanced request, and I
am new to using Visual Basic.