Excel Reading Pb

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.

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.

Thanks in advance,
With regards,
Bala



.

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)
  • 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)
  • CREATE TABLE - Spreadsheet and name range?
    ... I'm trying to make an excel file with ADO in MFC. ... sql query and then insert rows into the table. ... noticed that CREATE TABLE will create a spreadsheet and a name range. ...
    (microsoft.public.data.ado)