Re: ADOtable Excel
From: Brian Bushay TeamB (BBushay_at_Nmpls.com)
Date: 06/30/04
- Next message: Brian Bushay TeamB: "Re: CommandTimeout - TDataSetProvider/TADOQuery"
- Previous message: Sudianto Atek: "Re: sorting data with aggregatefield in sql statement"
- In reply to: Bob_M: "ADOtable Excel"
- Next in thread: Viatcheslav V. Vassiliev: "Re: ADOtable Excel"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
Date: Tue, 29 Jun 2004 22:48:31 -0500
>I would like to read the a few cells for data from an Excel file. I have
>done this with ADO and Access but can't get it to work with Excel. Below is
>my code. How would I get cell A1 from sheet1? Thanks Bob
from ADO the Excel data is treated like a table so you read the row your cursor
is currently on.
TadoDataset1.fields[0].asString reads the first field in the current row.
Brian
-- Brian Bushay (TeamB) Bbushay@NMPLS.com
- Next message: Brian Bushay TeamB: "Re: CommandTimeout - TDataSetProvider/TADOQuery"
- Previous message: Sudianto Atek: "Re: sorting data with aggregatefield in sql statement"
- In reply to: Bob_M: "ADOtable Excel"
- Next in thread: Viatcheslav V. Vassiliev: "Re: ADOtable Excel"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]