Member Avatar for Krefie

Hi guys/gals

Ok here is my problem, when importing data from excel using ADO, delphi doesn't seem to be able to import mixed column values...e.g. the column is formatted to integer and the integer values correctly import into delphi, but the same column contains string values it imports nothing or null.

It doesnt help changing the format either, I do not know why. So how do i get delphi to import multi values cells?

any help welcome!

Krefie

  • 2 Contributors
  • 1 Reply
  • 160 Views
  • 11 Hours Discussion Span
  • Latest Post Latest Post by Wolfgan
Member Avatar for Wolfgan

Use COM.
fObject := CreateOleObject('Excel.Application');

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.