Sign In| Join
Get Help:Ask a Question in our Forums|Report a Bug|More Help Resources
Last post May 09, 2012 03:29 PM by asp.netx.0lover
Member
39 Points
130 Posts
May 04, 2012 11:33 AM|LINK
want to uplaod decimal data like this 0000195.0000 so i set the data type in schema.ini file as double or float but after loading
the value came as 195.what data type should be set to get the data as like original
327 Points
107 Posts
May 04, 2012 03:10 PM|LINK
make it string, and when you need that, just type cast it into a number
362 Points
71 Posts
May 09, 2012 03:29 PM|LINK
The Schema.ini File (Text FileDriver) entry at MSDN implies there isn't a Decimal type. You might have to treat it as text, and then convert the text to Decimal via a conversion function.
sridevi.vmb
Member
39 Points
130 Posts
csv file uploaded
May 04, 2012 11:33 AM|LINK
want to uplaod decimal data like this 0000195.0000 so i set the data type in schema.ini file as double or float but after loading
the value came as 195.what data type should be set to get the data as like original
cYpH3r x3r0
Member
327 Points
107 Posts
Re: csv file uploaded
May 04, 2012 03:10 PM|LINK
make it string, and when you need that, just type cast it into a number
asp.netx.0lo...
Member
362 Points
71 Posts
Re: csv file uploaded
May 09, 2012 03:29 PM|LINK
The Schema.ini File (Text FileDriver) entry at MSDN implies there isn't a Decimal type. You might have to treat it as text, and then convert the text to Decimal via a conversion function.