Decimals Added To Varchar #'s After Import
Posted 21 March 2012 - 11:41 PM
Posted 22 March 2012 - 05:16 AM
Could you please provide us the dummy excel file where it is reproducible?
Actually, It is the driver that interprets datatypes from the source. There is a setting in the driver- Rows to scan. Change from Start-> Run-> ODBC data source administrator-> User DSN-> Select the Excel driver-> Options-> Rows to scan. This option specifies the number of rows to scan to determine the data type of each column. The data type is determined given the maximum number of kinds of data found. You need the increase the number of rows initially scanned(Refer screen-shot)The maximum value to be specified is 16. If you have have numbers in first 16 rows then it won't interpret as varchar and therefore a .0 to the end of it. There should be some text in atleast first four rows for the driver to interpret as varchar. Same thing would result using same driver and settings with any application.
Posted 02 August 2012 - 10:29 PM
Posted 03 August 2012 - 06:41 AM
0 user(s) are reading this topic
0 members, 0 guests, 0 anonymous users