MS Excel

Using Excel Datasources

Posted on June 2, 2002 by Chaz Scholton

This article covers using MS Excel files as datasources and originally was geared towards ASP but applies to other programming languages. This article is also useful if you have problems with the import of Excel data into a database.

Posted in Data, MS Excel | Leave a comment

Excel Spreedsheets SQL Table Names

Posted on May 20, 2002 by Chaz Scholton

There are 3 ways you can reference a table (or range) in an Excel workbook in your SQL Queries. Use the sheet name followed by a dollar sign (for example, [Sheet1$] or [My Worksheet$]). A worksheet table that is referenced … Continue reading →

Posted in Data, iHTML, MS Excel | Tagged | Leave a comment