Thursday, February 17, 2005

Anti spyware from Microsoft.

This is the best stuff I have seen from Microsoft in a long time. Thanks for the good stuff!

csvFiles .net connection strings

Hello ,
I have encountered problems with .net string with excel files.
Personally I think this is a bad problem that MS doesn't care much

I have a question about using .net to access excel data.

I want to do this using the connection string like:
Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\Book1.xls;Extended Properties="Excel 8.0;HDR=YES;

and the command "select * from [Sheet1$]"

However when I do this, if a column has a mixture of number and
alphanumeric records, it Only gets the numeric records.

Like if you have in column A


The datatable is only populated with the numbers, because the
provider thinks its being "smart" and assuming the top are number

DeleteFilesOlderThan and RSSBandit

RSS Bandit is now what I use as my rss reader. Very nice tool and
whish it had publication utilities. Currently I am trying just email
for publishing my blog content.

I recently write a quick program called "DelFilesOlderThan"

Its a consol app that deletes files and the commandline you give it is
in days like :

DeleteFilesOlderThan 30 *.log

It is a handy tool that can be run in scheduler to keep directory
clean of log files.

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.