Anti spyware from Microsoft.

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

http://www.microsoft.com/athome/security/spyware/software/default.mspx

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
about.

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

141
142
143
144
145
146
147
148
14B
ABC

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

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.

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.

Fox