Set the ODBC connection string and instruct the Import Engine to use ODBC mode.

This instruction is used by the TapeTrack Import Engine.

SetODBC(odbc);

• odbc The ODBC connection string.

SetODBC: Select the Microsoft Access Driver and pass the Access file to use.

SetODBC("Driver={Microsoft Access Driver (*.mdb)};Dbq=C:\Data\Sync\Tapes.mdb");
SetSQL("SELECT Barcode,Location FROM [Inventory]");

SetODBC: Select the Microsoft Excel Driver and pass the Excel file to use.

SetODBC("Driver={Microsoft Excel Driver (*.xls)};Dbq=C:\Data\Sync\Tapes.xls");
SetSQL("SELECT Barcode,Location FROM [Inventory$]");