Slow "Save As" in Microsoft Office Applicaitons

February 13, 2006

It seems we've been having a problem a lot lately with slow saves when choosing "Save As" in Microsoft Word and Excel.

This post is mainly a place to keep track of some of the ideas I've come across. There is a Microsoft KB article for example

If the slowness comes when choosing a different drive it is likely the matter of a having a disconnected network drive that needs to be removed.

Loading Microsoft Excel data into MySQL

June 24, 2003

This is mainly a cheat sheet for me in recalling the best way to load MS Excel data into MySQL.

Set dates to format YYYY-MM-DD
Put columns in the same order as the database
Save data as tab delimited
Use BBedit (or another program) to convert line breaks to UNIX (^n)
Put file in directory with no spaces in the path
Launch MySQL
Load data with command "load data infile '/PATH/FILE' into table `TABLE_NAME` LINES TERMINATED BY '\n';"

This is not comprehensive nor does it deal with all situations. Just a place holder for the information.

Excel how-to

June 3, 2003

This is an entry more for my record keeping than any other reason. The question is how to best create summary tables in Excel. The data I have has a row for each customer and sets of columns for each month. Each customer row had data in only one set of columns. Subtotal gives an easy way to consolidate this data onto a single line. The problem comes in that if you copy the excel data with the sub-rows hidden they show up in the pasted data

The solution: This only happens if you paste into Excel. Paste into a text editor, select all and paste back into Excel and voila. All is good.