Hello.
I have createe an Excel file with ActiveX and I defined type of columns 
(NOM,DEN and IMP).
Type text, text and money.
Why when I append a recor the IMP seams text and the column hasn´t the type 
money?
Is it possible to save the date in the original defined type?
Regards.
César.

Csar Calvo <ccalvoc@telefonica.net> wrote in
news:23773d1a$78544415$6941b@news.alaska-software.com: 

> I have createe an Excel file with ActiveX and I defined type of
> columns (NOM,DEN and IMP).
> Type text, text and money.
> Why when I append a recor the IMP seams text and the column hasnt the
> type money?
> Is it possible to save the date in the original defined type?

Here is what a google search found:
https://msdn.microsoft.com/en-us/library/ms712640(v=vs.85).aspx

currency fields are represented as a numeric in odbc. This is a limitation 
of the microsoft ODBC driver!

Best regards,
Boris Borzic

http://xb2.net
http://sqlexpress.net
industrial strength Xbase++ development tools