This is a very quick note on converting Office files, because I know I’ll need it someday…
Our dear friend @LadyRuna (Andie LeTourneau) asked for help on Twitter today; someone had sent her an Excel file that was saved as a later version than she had installed. After many recommendations from the Tweeps, she said:
High Five from ME to OpenOffice.org – Opened xlsx in Calc, converted to csv. Now import to SQL time. Thanks to all for suggesitons #sqlhelp
That will DEFINITELY come in handy some day, I just know it.
News
By the way, we got all moved in to the new house yesterday; it was a VERY long day, but we’re still very excited.
Sean presents at NTSSUG tonight at 6pm, followed by Brad McGehee (blog, Twitter) at 7ish. Tomorrow is SQL Saturday35 Eve, and Saturday is the big day!
-Jen
Didnt see the tweets earlier but why not just use the free addon for office 2k3 that enables opening newer formats? If you have rights to install OO, then surely a small addon should be no problem and a lot quicker…