Copying data from one Access database to another

[Dave Henson]

I am working on a project where I need to get data from an Access database
uploaded daily by my client and copy fields from various tables into
corresponding fields in corresponding tables in a second Access database.
Both databases are set up as separate datasources within ColdFusion.

Not that it's probably relevant, but I do not have access to the web server
as it is on a shared box with my ISP. I will need to carry this out daily
using a scheduled task.

Thanks,
Dave Henson.

[Dave Henson]

"Dave Henson" <novamedia1999@hotmail.com> wrote in message
news:3lu808F14g1hoU1@individual.net...

>I am working on a project where I need to get data from an Access database
>uploaded daily by my client and copy fields from various tables into
>corresponding fields in corresponding tables in a second Access database.
>Both databases are set up as separate datasources within ColdFusion.
>
> Not that it's probably relevant, but I do not have access to the web
> server as it is on a shared box with my ISP. I will need to carry this out
> daily using a scheduled task.
>
> Thanks,
> Dave Henson.
>

Sorry, just re-read my post and realised that I didn't ask the relevant
question. Can anybody tell me what is the best way to get the data from one
database to the other?

Thanks
Dave.