Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Search results for query: *
- Users: captainjim1
- Order by date
-
OLEDB excel import only selecting "string" values.
Ahh I just found it. In the extended properties if I set IMEX=1 then it works. I have no idea why, but I saw it mentioned somewhere else on this forum and it fixed it. -Captain Jim- captainjim1
- Post #4
- Forum: Microsoft: ASP.NET
-
OLEDB excel import only selecting "string" values.
I am having the same problem. In the extended properties of your connection you can specify that there is no header row.. HDR=No; This doesn't resolve the problem for me, but it might be the problem for some with missing data. I've tried converting the datatypes to strings in the SELECT...- captainjim1
- Post #3
- Forum: Microsoft: ASP.NET
