Started out smoothly. I got to work on it during my lunch hour. As I said before if you think of suggestions I would love to hear them.
I am not going to use MS Word for a dictionary at this point. Rather I am unsing an online dictionary. If I should choose to move to another source it will be fine as I will have the logic down.
Basically I am going to refer you to a past blog entry
and show you the keywords it would have generated and then the keywords it did not choose to generate, either cause the words were too short, not a noun or were numbers.
Right now this is just the logic. We will work on the gui and options later.
The text contained in the entry:
Fix: Jet can get the datatype wrong with Excel as data source using vb.net
Good Morning. I cannot believe what happened on "The Shield" last night. All of Mackey’s talk about loyalty and family went straight down the tubes when his butt was on the line. Is there anyone left routing for this bastard? I think for a lot of us, it is like we want to see justice served and see this guy go down in flames. it’s a car wreck and we can’t turn away. Next week is a 90 minute episode and believe you me I will be taping this one.
Anyway, I really struggled with this. When connecting to an excel spreadsheet the Jet Engine "fixes" the datatypes with reference to a scan of some rows and then produces NULLS when subsequent values in that column do not conform to that fixed datatype: specifically text in number columns. This is what I came up with and I have attached the spreadsheet. I hope you never have to deal with this problem. Don’t forget to change the path for the attached spreadsheet. Make it a great day!
End of entry……
Keywords That Would Have Been Generated (at this point):
Words It Ignored listed with the type of word the dictionary said it was. One word, I have got to find a way to have the logic include was "Excel" as that was critical to it. But not bad for a start. It thought "Excel" as in being good at something not the program.
will auxiliary verb