warehousing collected data

[Vic]

We collect data from external contractors that is supplied on floppy
or Cd in an access mdb file. these files have the same structure but
have different names.We wish to upload this data into a central access
database.Is there a function or a module that could do this
automatically.

[Allen Browne]

In the database the contractors supply you, you could include an Append
query that appends to your database. Naturally the query would not work if
they tried it when the target database was not available.

If you prefer to go the other direction, check out the TransferDatabase
action/method. If you need the user to select the file for input, see:
http://www.mvps.org/access/api/api0001.htm

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Vic" <vm******@sewl.com.au> wrote in message
news:6a**************************@posting.google.c om...

We collect data from external contractors that is supplied on floppy
or Cd in an access mdb file. these files have the same structure but
have different names.We wish to upload this data into a central access
database.Is there a function or a module that could do this
automatically.