(no subject)

[chess]

Right.

I have a text file, with dates in American format - m(m)/d(d)/yyyy, so today is 2/15/2002. Amongst a lot of other stuff, and I'd like to keep all the otherstuff the same.
I need to make a nice stand-alone-executable program which will just swap the month and day bits of each date it comes across around. (they're all a certain number of tabs (with otherstuff between the tabs) after a newline, if that helps.) This is because Access refuses to parse American dates from linked text files if your Windows regional settings are set to UK.
Any help / ideas as to how I could get this done?

Comments

[jaq.livejournal.com]

Perhaps you could make Access read that column as plaintext and write a VB function to convert it, then use it in a query with the date as a calculated field.

[chess]

Ooh. Now, if only I knew the first thing about VB, or Access in general...