Argh!

[dancerjodi]

Access update: I'm still fighting with it. These are the annoying little issues that seem like they should be so simple, and yet take hours to figure out.

So far I've:
Searched in Google
Searched in manuals
Searched the MS Access Help file
Asked an MS Access trainer
Asked a data analyst at Partners Health Care
Asked an IS person at Partners Health Care
Asked an old co-worker from THP
Asked a random stranger who found my LJ I'm guessing from someone on his friend's list.

This is just silly! It shouldn't be so difficult to change a text variable to a date.

Comments

Access issue

[dancer.livejournal.com]

"What is the format of the date in the raw file?"

Its in .txt format. I wish I could get it into another format, but its too big to open in Excel, and I don't have any software available to me that could convert it to a .dbf (which is what some of my old co-workers suggested I do).

"I have had occasion in which I to play with the format before bringing into Microsoft."

Yeah, its too bad I can't do that (since all I have to work with is Excel - that won't read in all of the rows).