An Application for Transferring Data

You can create an application that uses SQL-DMO to build a database and to insert rows using data from another source (such as a mainframe or hardware that generates statistics). The program could retrieve data through a third-party control, driver, or gateway.

You can use Visual Basic to read the data and manage simple insertion of data using the Database object's ExecuteImmediate method to insert the data.

This is an example of where it may be more appropriate to use ODBC or DB-Library. The decision to use ODBC or DB-Library depends on whether the application requires only data manipulation tasks. If the application requires mostly data definition tasks, then SQL-DMO is more suitable.