How do I connect to xls files? <br>How do the databases/tables work?, <br>is an excel workbook a single table <br>or each excel sheet is a table? <br>Which workbook do I have to select when I'm setting up the ODBC DSN? <br> <br>WOW, too many questions on a row... sorry, but I'm new on this topics.

This isn't something we would generally do. A quick search I tried on the MS Knowledge Base suggested that using Excel as a database is extremely limited. <a href="http://support.microsoft.com/default.aspx?scid=kb;en-us;178717" target="_new">http://support.microsoft.com/default.aspx?scid=kb;en-us;178717</a> (No Update or Delete statements, for example, so you can only Insert and Select.) <br> <br>In the MS Excel Help file, if you search the Index for 'driver', the second result (in the version we use here) has help on setting up a data source using the Excel driver. <br> <br>Since we haven't used this extensively, I don't know how it will hold up in the long term. I would suggest against using this as your database, as my guess is that between the limitations mentioned above, and any others that arise will make using it difficult at best. If you do wish to use it despite this, you will need to investigate how it works, and how (if at all) it will work in a busy system.