cp /mnt/com/ebay/completed_auctions/ps3 ~/ps3.txt ?? [more inside]
posted on Jul 23, 2008 - 6 answers

What's the easiest way to merge data from multiple Excel worksheets into one big worksheet [more inside]
posted on Jul 21, 2008 - 2 answers

How can I get data from the USDA's food database into excel? [more inside]
posted on Jan 5, 2008 - 8 answers

I need suggestions for an application (or database) to help my employer keep better track of live-trivia scorekeeping results. They are currently doing it all in various separate Excel spreadsheets, and this is (almost) 2008, so I'm sure there must be a better way. [more inside]
posted on Dec 24, 2007 - 3 answers

Please help me create an expandable excel function that can find and extract cell rows. [more inside]
posted on Oct 11, 2007 - 5 answers

How do I add a 4,000 name MS Excel file to an existing MS Access database? [more inside]
posted on Jul 2, 2007 - 3 answers

Excel-filter: I have a spreadsheet with a list of donations made over the past year. Unfortunately, when an individual has donated multiple times within a year there is a new row for each donation. Fortunately, that individual is assigned the same unique identifier. How do I make it so that each individual has one row with total donations for the year? [more inside]
posted on May 1, 2007 - 6 answers

Is there an easy, preferably open source way of editing MySQL table contents? I was hoping for something which would let me use Excel (or OO Calc) to edit the live database. I need to search/replace many items in a poorly imported database. [more inside]
posted on Feb 6, 2007 - 10 answers

I have a data set of approximately 9,000 hip-hop tracks. It's in an Excel file. I have the song title, the artist, and the album. Now I just need the year. How can I find and automatically import the year into the Excel file without manually looking up every track on Google? Is there a way to do this with MusicBrainz or a similar database?
posted on Jan 26, 2007 - 9 answers

I have an Excel Spreadsheet (using Excel 2003). Rather than creating formulas to answer ad hoc questions that I have, I would like to be able to quickly type in a SQL querty against the data in the spreadsheet. So, I could scroll down to the bottom of the sheet to see how many rows I have, OR I could type" select count(*) from data_table" instead. I prefer the latter. Any suggestions? [more inside]
posted on Apr 7, 2006 - 6 answers

Basic Microsoft Excel question. How do I join two databases together when they share elements but are not coextensively equal? (More) [more inside]
posted on Jan 22, 2006 - 8 answers

Database 101... I have two tables, with one common field, an ID number. One table has many more records than the other. How can I tell which records in the 'big' table are also in the 'small' table? [more inside]
posted on Sep 2, 2005 - 5 answers

Invoicing with MS Excel--squeezing relational database features out [MI]
posted on Feb 17, 2004 - 10 answers