WILDandWACKY
Programmer
Help guys!!!
I need to export data from several sites, each using Microsoft Access (some use 2000 and some use XP in 2000 mode), e-Mail it and then import it into a 'master' version of the database.
I reckon I'm a bit stupid (it's Monday morning here in the UK, so I reckon I'll blame that for me going a bit simple in the head!!) cos I can't work out the best way of doing it. There are a few export routines in Access but I can't work out the import - also I need to export just a selection of the records in the table (via a query???), not the whole table.
To make life harder I want to code the data if possible - this isn't essential, but I'd like to.
HELP!!!
I need to export data from several sites, each using Microsoft Access (some use 2000 and some use XP in 2000 mode), e-Mail it and then import it into a 'master' version of the database.
I reckon I'm a bit stupid (it's Monday morning here in the UK, so I reckon I'll blame that for me going a bit simple in the head!!) cos I can't work out the best way of doing it. There are a few export routines in Access but I can't work out the import - also I need to export just a selection of the records in the table (via a query???), not the whole table.
To make life harder I want to code the data if possible - this isn't essential, but I'd like to.
HELP!!!