Wednesday, February 29, 2012 8:09 PM
Hello I do have CSV files and I'm loading in to datatable
COL1 COL2 ==== ======= 1 45 2 5 1rf 5 45 5
Now I'm having issue that I'm not able to get 1rf value in to data table.
please advise me
Wednesday, February 29, 2012 11:35 PM
Here you go for the solution :
Unfortunately, you can't set ImportMixedTypes or TypeGuessRows from the connection string since those settings are defined in the registry. For the ACE OleDb driver, they're stored at
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Office\12.0\Access Connectivity Engine\Engines\Excel in the registry
[HKEY_LOCAL_MACHINE\Software\Microsoft\Jet\4.0\Engines\Excel\TypeGuessRows ----> TypeGuessRows =0;
- Marked As Answer by Lie YouModerator Friday, March 02, 2012 7:22 AM
Friday, March 02, 2012 7:22 AMModerator
Thanks for sharing it here.
Glad to hear you got a solution.
MSDN Community Support | Feedback to us