The Archn00b
Registered User.
- Local time
- Yesterday, 20:07
- Joined
- Jun 26, 2013
- Messages
- 76
Hello everyone,
I have an append query that I would like to use to distribute records to a variety of databases. Some records will go to one, others to a second and so on.
I have an idea as to how this would work in Visual Basic, but how can I make an append query work through a table on a record by record basis?
I'm assuming that this whole task is best done in VB, but I might be able to do it in SQL?
Thanks!
I have an append query that I would like to use to distribute records to a variety of databases. Some records will go to one, others to a second and so on.
I have an idea as to how this would work in Visual Basic, but how can I make an append query work through a table on a record by record basis?
I'm assuming that this whole task is best done in VB, but I might be able to do it in SQL?
Thanks!