Home....
Developer Network >> Other Programming >> Database

Excel Select Single Columns

Hi
My problem is that I want to select specific columns of an excel spreadsheet that are not connected (-> no CellRange possible). I'm connecting to the spreadsheet using ODBC with a SQL-Statemanet like "SELECT * FROM [Sheet1$]"
This selects al the data in the spreadsheet. BUT I only need the columns A, B, X and Y (for example). So selecting al the other columns too slows down the speed considerably...
I found out how to select a CellRange: "SELECT * FROM [Sheet1$A1:B100]" ...
Please Help!!
[519 byte] By [DarkLizener] at [2007-11-19 11:00:21]
«« Troubleshoot SQL Server Connection
»» Disable Enable screen saver
# 1 Re: Excel Select Single Columns
Well either redefine the area on the spreadsheet to include the missing data or use OLE! ODBC requires that the table be a defined area in excel.

If you care to learn OLE!

Here is the How To:

http://www2.ari.net/tobywan/VCPPinstr.html

Here are source examples:
http://www.tek-tips.com/viewthread.cfm?qid=246661

ahoodin

PS If this post helped, don't forget to rate. Just click the scale icon and then click the approve radio button on the resultant dialog.
ahoodin at 2007-11-9 13:41:58 >
Other Programming
Database

Other Programming

All Classified

Other Programming New Topic

Other Programming Hot Topic