title: Connect Flat files using java jdbc
body: <p>I have a problem with connecting flat files(.txt, .xml, .csv, .xls, etc...) which is existing in application it's self, using jdbc connection.</p>
  
  <p>After searching I found some suggestions below.</p>
  
  <p>1)<a href="http://xlsql.sourceforge.net/." rel="nofollow">xlsql</a><br>
  2)<a href="http://www.oracle.com/technetwork/java/index-jsp-135919.html" rel="nofollow">JDO</a></p>
  
  <p>I tried with <strong>first one (xlsql)</strong>, below is the process.
  First create core java project and load the jar files which is from xlsql.
  below is the code</p>
  
  <pre><code>Class.forName("com.nilostep.xlsql.jdbc.xlDriver");
  final String dir = System.getProperty("user.dir")+"\\db\\xl";
  conn = DriverManager.getConnection("jdbc:nilostep:excel:/"+dir);
  Statement stmt = con.createStatement();
  String sql = "select * from  Sheet1$";
  ResultSet rs = stmt.executeQuery(sql);
  if(rs.next()){
  System.out.println(rs.getString(1));
  }else{
  System.out.println("nodata....");
  }
  </code></pre>
  
  <p>It is saying Sheet1$ table not existing.</p>
  
  <p>Please help me.</p>