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


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 ?

VB multiple database transfer

Visual Basic is Microsoft’s event-driven programming language and integrated development environment (IDE) for its Component Object Model (COM) programming model. It is relatively easy to learn and use because of its graphical development features and BASIC heritage. It has been replaced with VB.NET, and is very similar to VBA (Visual Basic for Applications), the programming language for the Microsoft Office product line.