Last post Dec 17, 2013 06:30 AM by waqar1
Dec 10, 2013 09:23 AM|waqar1|LINK
Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\SigmaFlow Projects\BPI\NewTFS\Insight\Insights Web\TempFiles\xbumrsw05bs53x52gojp0tayH\;Extended Properties='text;HDR=YES;IMEX=1;'
oledb filling data but ignoring the entire value which is cosist of alphanumeric.
Dec 10, 2013 10:11 PM|Michelle Ge - MSFT|LINK
According to your description, I'm not very understanding the error message.
So far as I know the connectionstring should be as below:
There is a similar thread, please refer to the link below:
Hope it's useful for you.
Dec 11, 2013 01:30 AM|waqar1|LINK
it is giving me error "unspecified error" when i enter FMT=Fixed.
Dec 11, 2013 01:45 AM|prk_in|LINK
Dec 11, 2013 02:34 AM|waqar1|LINK
no relevant to my issue
Dec 12, 2013 01:24 PM|waqar1|LINK
Ultimately I got a solution to change the registry, then it works fine but it is not a goood solution.
Dec 17, 2013 06:30 AM|waqar1|LINK
There is option of Importmixedtypes=majority
I changed it to text. so it is accepting alphanumeric,number & text etc.