====== SetODBC ====== Set the ODBC connection string and instruct the Import Engine to use ODBC mode. ===== Phase ===== This instruction is used by the TapeTrack Import Engine. ==== Syntax ==== **SetODBC**//(odbc);// * ''odbc'' The ODBC connection string. ==== Example ==== 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]"); ==== Example ==== 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$]");