Re: Excel Reading Pb

Bala wrote :
Hi !

We are trying to read Excel file from Delphi 5 using ADO.

When the Excel file is fully created by the program, no problem. But when
certain cells are copied from another file and pasted to the file read, we
find certain field values in the column above the pasted cells are not read.

never encountered this and I am using ADO to read excel files for the past 5 years now. Something else is moved around with the data pasted try to key in the data and see if this changes anything.

Another question in this regard, is it recommended to use ADO when the Excel
file contains multiple rows at the top (in our case 5) before the data
starts. Data of different columns have different data types.

Since you can address the excel file as a dataset you can ignore as much row as you need before you start reading the actuall data. On the same regard I never ever use the data type reported by the excel driver I just assume that all data are coming in as strings and convert them to the destination data type as needed manually.


regards
Yannis.

--
Problems worthy of attack prove their worth by fighting back.
- Paul Erdos (1913-1996)


.

Relevant Pages

  • Read excel files with ado.
    ... I'm trying to open an excel file with ado. ... With a different script I found that ado cannot find the adox.catalog table object in the ... Set oConnection = createobject ...
    (microsoft.public.scripting.vbscript)
  • Using ADO.Net to Create and Alter an Excel File...
    ... Next I want to use DataReader to read the data from the "backup of..." ... So how do I build the string I need to create the blank excel file ... using only ADO? ... I cannot guarantee that excel is installed on the PC ...
    (microsoft.public.dotnet.framework.adonet)
  • RE: Access Query with Password
    ... I have some bad news for you: you can't use ADO to open a password-protected ... Excel file: ... there is a workaround: it is possible to use ADO if you first open ... "Dominator" wrote: ...
    (microsoft.public.excel.programming)
  • Excel Reading Pb
    ... When the Excel file is fully created by the program, ... find certain field values in the column above the pasted cells are not read. ... Another question in this regard, is it recommended to use ADO when the Excel ...
    (borland.public.delphi.database.ado)
  • Re: Controlling free Excel reader with VB or VBA?
    ... >> I'd import the Excel file into an Access database and write the user ... >> interface for that in VB. ... I'd use ADO, but anything will work. ...
    (microsoft.public.vb.general.discussion)