Next: Google Reader Blows. Previously: RSS Feed Fixed.

Excel Spreadsheet Table Names

8 January, 2008. 84 words.

If you have the unfortunate need to use an Execute SQL Task SSIS component on an Excel spreadsheet, make sure you specify the worksheet name as “[Your Sheet 1$]” in the FROM clause of your SQL statement. I spent a while trying to track down the correct format, as it is not at all obvious from the error messages that result if the name is wrong. (No, I don’t often work with Excel spreadsheets as data sources and I hope I never do again.)

Next: Google Reader Blows. Previously: RSS Feed Fixed.

This page is a static archival copy of what was originally a WordPress post. It was converted from HTML to Markdown format before being built by Hugo. There may be formatting problems that I haven't addressed yet. There may be problems with missing or mangled images that I haven't fixed yet. There may have been comments on the original post, which I have archived, but I haven't quite worked out how to show them on the new site.

Sorry, new comments are disabled on older posts. This helps reduce spam. Active commenting almost always occurs within a day or two of new posts.

Related