Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
access a column via a select statement
Hi,
I am trying to access a excel spreadsheet using the OleDB. I have been able to open the worksheet up, but it would seem that I can only perform 'select * from [sheet1$]' I want to be able to select only a small number of columns from the sheet, but when i try 'select A,B from [sheet1$]' it causes an error. Is there a specific syntax to access Column A/B in a select statement ? Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
VBA: Column Select then Data Select then return to cell A1 | Excel Discussion (Misc queries) | |||
For...Next or Select Case Statement | Excel Programming | |||
Trouble with select statement | Excel Programming | |||
SELECT statement | Excel Programming | |||
Adding SQL Select Statement | Excel Programming |