Tuesday, February 15, 2005

excel to datatable and csv files

oledb and excel and other problems.

My goal is to find an easy surefire way of putting csv files made different ways into a datatable. And excel. I am going to try again using the connect string with excel instead of the com objects used to gain access to those files. Hopefully using imex=1 in my connection string will make all the characters retrieved string data types.

Wish me luck.



Post a Comment

<< Home