Re: Excel Reading Pb

Thanks Yannis. Now it is working. We had not added IMEX =1, when we added
this everything is fine.

Thanks again.

With regards,
Bala

"yannis" <none@xxxxxxxxxx> wrote in message
news:mn.abb87d830918afc6.0@xxxxxxxxxxxxx
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

  • Re: linking or merging to Excel
    ... you can do the EXCEL save as via Automation. ... the data type is correct. ... Otherwise, you could use Automation to open the EXCEL file, read each row ... prior to importing but it still imports as a number. ...
    (microsoft.public.access.gettingstarted)
  • Re: Running Excel Addin from VBA in Access....HELP!!
    ... You initially build a macro in Excel to do what you want, ... imbeds it in an Excel file of your choosing, then runs it as a macro. ... code that creates an Excel file, ... Dim objUniqueTeams As Object ...
    (microsoft.public.access.modulesdaovba)
  • Re: importing from excel to access
    ... Current versions of ACCESS do not let you specify the data type of the ... Depending on the data that are in the EXCEL file, ... Go back to the EXCEL file, go to the bottom of your data rows, and then ...
    (microsoft.public.access.externaldata)
  • Re: Excel Importing.... Fact or Fiction?
    ... You can avoid this problem by creating a "calculated" Column in Excel using ... the TEXTworksheet function to convert the mixed Column to all Text. ... > I have an Excel file needs to export to an Access table. ... > column "Zip Code" the data type was set to "General" to allow both numeric ...
    (microsoft.public.access.forms)
  • Re: Merge field link to database returns value w/255-character limit.
    ... When Word 2002/2003 gets data from an Excel file, ... specific data type for each column in the worksheet. ... So the OLEDB provider looks at the first 25 rows of each column and applies ...
    (microsoft.public.word.mailmerge.fields)