JDBC for SQL Server - Herong's Tutorial Examples - v3.14, by Herong Yang
JDBC-ODBC - Tab Delimited Flat File Data
This section describes how to enter data in a flat text file as tab delimited columns.
To do further testing with the ODBC text file driver, I entered some data manually into two files in the directory connected to my DSN. My data is organized in columns with the tab character as the column delimiter.
1. C:\LOCAL\ODBC_FLAT_DB\User.txt:
ID FirstName LastName BirthDate AddressID 1 Christopher Kleinerman 11-Aug-1989 5 2 Rosmarie Kobylinski 01-Jul-1983 4 3 Alexander Mendiola 12-Apr-1977 3 4 Danielle Alexander 05-Nov-1979 2 5 R. Morgan Van Houten 09-Sep-1985 1
2. C:\LOCAL\ODBC_FLAT_DB\Address.txt:
ID StreetName City 1 5 Baker Road Bellevue 2 25 Bay St. Hull 3 251 Main St. W. York 4 99 Wade Ave Paris 5 998 Forest Portland
As you can see, these two files contain data for two related tables. The AddressID in the User.txt file links to the Address.txt file.
Table of Contents
JDBC (Java Database Connectivity) Introduction
Microsoft SQL Server Express Edition
Microsoft JDBC Driver for SQL Server
Microsoft JDBC Driver - Query Statements and Result Sets
Microsoft JDBC Driver - DatabaseMetaData Object
Microsoft JDBC Driver - DDL Statements
Microsoft JDBC Driver - DML Statements
SQL Server - PreparedStatement
SQL Server CLOB (Character Large Object) - TEXT
SQL Server BLOB (Binary Large Object) - BLOB
Using Connection Pool with JDBC
JDBC-ODBC Bridge Driver - sun.jdbc.odbc.JdbcOdbcDriver
►JDBC-ODBC Bridge Driver - Flat Text Files
JDBC-ODBC - Creating DSN for Flat Test File
JDBC-ODBC - Connecting to Flat Text Files
JDBC-ODBC - Getting Flat File Driver Info
JDBC-ODBC - CREATE TABLE in Flat Text Files
JDBC-ODBC - Listing Tables with meta.GetTables()
►JDBC-ODBC - Tab Delimited Flat File Data
JDBC-ODBC - ODBC Configuration for Flat Files
JDBC-ODBC - Executing Queries on Flat Files
JDBC-ODBC - Missing Flat Data Files
JDBC-ODBC Bridge Driver - MS Access