title: Using Excel as an ODBC database
body: <p>I'd like to know, how to create a database table in Excel, so that it may be used with ODBC</p>
  
  <p>I want to use ODBC, and I have two options, either MS Access or Excel,   </p>
  
  <p>As you probably know, in order to indicate some MS Access file or Excel file as an ODBC source, you need to follow:</p>
  
  <p>Administrative Tools -> Data Sources (ODBC) -> Choose User DSN -> Choose either 'Excel Files' or 'MS Access Database' from the list -> Press 'Configure' -> finally choose the file (MS Access or Excel) as ODBC source</p>
  
  <p>Well, it works fine with MS Access, I can connect to the file and see all tables that I've created inside</p>
  
  <p>But when it comes to Excel, although I can connect to the file, I can't see the table that I've created inside </p>
  
  <p>I just used 'Table' in 'Insert' tab, added some headers as column names, and gave the table 
  a meaningful name. Is that the way to do it?</p>