Thread: Cannot retrieve string data in CSV and Excel files
View Single Post
  #11 (permalink)  
Old February 20th, 2006, 06:24 AM
jitendersingal jitendersingal is offline
Authorized User
  
Join Date: Feb 2006
Posts: 10
Thanks: 0
Thanked 0 Times in 0 Posts
Default
solution for this problem is to put 'IMEX=YES' Attribute in connection of oledb.this fetches the data from the excel column as text format.

try it
this will work

Reply With Quote