VB multiple database transfer

This is more SQL than VB , but here goes...
If I have shop branches with different
databases and I want to collate a report on sales at all branches, AND
the user only gets a VB interface to
do this, what is best method of
doing it ? Do I run stored procedure
that extracts local branch data then
gather that together into a central table for Crystal Reports. How
do I transfer the data - use some custom
interface to harness SQL data transfer
or just pass data as a byte stream
eg property bags ?
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Ok, here goes, you must change this sollution to suit your environment.  On the client where you want your program to run, create an access database with attached tables to each of the machines you want to summarize.  On that local machine you can then access the data from each machine.  You could even create views to (kind of) concatenate the data, into a more manageable single table, you could even append a machine name for ease to identify the source of the data.

Yes it is possible, spin the wheel.

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Visual Basic Classic

From novice to tech pro — start learning today.