Microsoft Excel

Slow "Save As" in Microsoft Office Applicaitons

13 Feb 2006
Posted by joshb

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.

Tags: | 39 Comments

Loading Microsoft Excel data into MySQL

24 Jun 2003
Posted by joshb

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

  1. Set dates to format YYYY-MM-DD
  2. Put columns in the same order as the database
  3. Save data as tab delimited
  4. Use BBedit (or another program) to convert line breaks to UNIX (^n)
  5. Put file in directory with no spaces in the path
  6. Launch MySQL
  7. 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.

Tags: | 1 Comment

Excel how-to

03 Jun 2003
Posted by joshb

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.

Tags: | Add a Comment
 
 
 

Live from twitter...

  • @emaildiva Yes I've got it on a few sites that aren't yet public and it's a really well put together theme.
  • @emaildiva In looking for good Drupal themes might check out this recent post on Acquia Marina. Lots it can do. http://bit.ly/1rYxLH
  • @dancourse best Drupal book is relative to what you're trying to do....
  • It's funny that we can name boys with their father's names but for some reason Sarah Jr. doesn't get real consideration??