> >
> > Hi!
> >
> > You can use SET FIXED ON to specify the number of decimals displayed. But the decimals are still there, you will only limit the number of decimals displayed e.g. when browsing. Putting the focus on the field will reveal its actual decimal size.
> >
> >

> > Set Fixed On
> > Import From Book1.xls Type XL5
> > Browse
> > Set Fixed Off
> > 

> >
> > Or you can use a select statement from the resulting table after the import command is executed.
> >
> >

> > Import From Book1.xls Type XL5
> > SELECT CAST(a as n(12,2)) as a FROM book1 Into Cursor Imported
> > Browse Normal
> > 

> >
> > (coffee)
> > My Blog Site:  Glenn Villar Blog
>
> oh..yeah good. thank how about HEADER not allowed
>
> ex.
> A B C D E F G
> No. Name Unitprice Stock TOTAL
> 1 Udin 2500 40 100000
> 2
> ...
>
> one more thx.

There is a situation similar to this on this post, Message ID: 197371


(coffee)
My Blog Site:  Glenn Villar Blog