Lammutaja
07-12-2005, 07:42 AM
Hi!
Can someone please help me in next problem:
I have two Access files. Let us name them A and B
I am filling A with data (3 tables) from Excel (with ADO).
The structure of these tables are the same for files A and B.
I have to export (in each morning for example or
by some another event) new data from file A to B automatically
(each table in file A has field "Export" and when data has not yet exported to B the value of "Export" is "No"; After exporting the data the value of the field "Export" will be "Yes").
How can I export the data with VBA automatically from file A to B when
some event occures?:dunno
J?ri.
Can someone please help me in next problem:
I have two Access files. Let us name them A and B
I am filling A with data (3 tables) from Excel (with ADO).
The structure of these tables are the same for files A and B.
I have to export (in each morning for example or
by some another event) new data from file A to B automatically
(each table in file A has field "Export" and when data has not yet exported to B the value of "Export" is "No"; After exporting the data the value of the field "Export" will be "Yes").
How can I export the data with VBA automatically from file A to B when
some event occures?:dunno
J?ri.