TapeTrack Documentation

Because there is more to tape management than you ever realized

User Tools

Site Tools

Trace:
engine:import:setodbc

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revisionPrevious revision
Next revision		Previous revision
engine:import:setodbc [2019/02/18 02:29] – [Syntax] Scott Cunliffeengine:import:setodbc [2025/01/21 22:07] (current) – external edit 127.0.0.1
Line 8: Line 8:
 **SetODBC**//(odbc);// **SetODBC**//(odbc);//
  
-  * string ''odbc'' The ODBC connection string.+  * ''odbc'' The ODBC connection string.
  
 ==== Example ==== ==== Example ====
 SetODBC: Select the Microsoft Access Driver and pass the Access file to use. SetODBC: Select the Microsoft Access Driver and pass the Access file to use.
  
-<sxh>+<code>
 SetODBC("Driver={Microsoft Access Driver (*.mdb)};Dbq=C:\Data\Sync\Tapes.mdb"); SetODBC("Driver={Microsoft Access Driver (*.mdb)};Dbq=C:\Data\Sync\Tapes.mdb");
 SetSQL("SELECT Barcode,Location FROM [Inventory]"); SetSQL("SELECT Barcode,Location FROM [Inventory]");
-</sxh>+</code>
  
 ==== Example ==== ==== Example ====
 SetODBC: Select the Microsoft Excel Driver and pass the Excel file to use. SetODBC: Select the Microsoft Excel Driver and pass the Excel file to use.
  
-<sxh>+<code>
 SetODBC("Driver={Microsoft Excel Driver (*.xls)};Dbq=C:\Data\Sync\Tapes.xls"); SetODBC("Driver={Microsoft Excel Driver (*.xls)};Dbq=C:\Data\Sync\Tapes.xls");
 SetSQL("SELECT Barcode,Location FROM [Inventory$]"); SetSQL("SELECT Barcode,Location FROM [Inventory$]");
-</sxh>+</code>
engine/import/setodbc.1550456945.txt.gz · Last modified: 2025/01/21 22:07 (external edit)