Exporting data range from Excel to Access

[Shep]

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/...php?t=envbadac

--
Regards Ron de Bruin
http://www.rondebruin.nl


"Shep" <Shep@discussions.microsoft.com> wrote in message news:CBFB2352-49C3-4B02-8FB9-4562C6AACD71@microsoft.com...
>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

[Shep]

That's perfect. Thanks so much Ron.

Shep


"Ron de Bruin" wrote:

> Hi Shep
>
> See this page
> http://www.erlandsendata.no/english/...php?t=envbadac
>
> --
> Regards Ron de Bruin
> http://www.rondebruin.nl
>
>
> "Shep" <Shep@discussions.microsoft.com> wrote in message news:CBFB2352-49C3-4B02-8FB9-4562C6AACD71@microsoft.com...
> >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
>
>
>