Tom Gleeson Datasmith
Fix-My-List Service - Micro ETL
Convert lists (database tables, spreadsheets, CSV files, XML files into another format (pivot tables, PowerPivot cubes, PALO cubes, one-to-many, many-to-one, XML to CSV, XML to SQL, etc.). Delivered either as a ...
SERVICE: Send the data to me, I'll return the finished dataset or...
DIY: I'll send you the "code" - usually an Excel Add-in - which you can then apply locally to transform your data.Excel Based BI
Twitter @gobansaor
- SQLite "data warehouse" http://bit.ly/baXpvu 4 minutes ago
- @tombarrett Wordpress.com ? 12 minutes ago
- @mcgconor A Tapas Bar in Naas! Is it good? 3 hours ago
- Had to fall back to this excellent CSV Streaming Editor http://bit.ly/cO1n7i to get job done when SQLite appeared to be failing me. 3 hours ago
- Should have know SQLite wouldn't be having malloc problems; SQLite's Dynamic Memory Allocation http://bit.ly/aFaibl is top class 3 hours ago
- It looks like pure SQLite3 is much faster than the SQLite wrapped BerkleyDB engine for large vol. (1 million plus) inserts. 3 hours ago
- Was having trouble loading 1.8 million rows into SQLite (Malloc error)!!! Turned out I was accidently using BerkleyDB SQLite engine; whew! 3 hours ago
- This #PowerPivot ODBC problem appears to be a know bug http://bit.ly/cqKPWM 9 hours ago
- Getting "ERROR [HY000] near "*": syntax error (1)" when using ODBC import in #PowerPivot; works okay if I provide SQL but not on import all 9 hours ago
- Happy (belated) 10th birthday, SQLite http://bit.ly/bJd6yP 12 hours ago
-
My Bookmarks (del.icio.us)
-
Recent Comments

VBA & JavaScript… on JavaScript as an Excel scripti… gobansaor on LightSwitch & Hobo –… ross on LightSwitch & Hobo –… 
LightSwitch & Ho… on SQL – does exactly what … 
LightSwitch & Ho… on Time Assets -
Recent Posts
- LightSwitch & Hobo – the return of the 4GL?
- Micro ETL in the PowerPivot age
- Power (Pivot) to the People
- Star Schemas – to boldly go where no Excel spreadsheet has gone before
- PowerPivot – Show Detail not allowed!
- SQLite XML Streaming Virtual Table via Expat
- JavaScript as an Excel scripting language via JSDB
- Time Assets
- SAX and Bugs and XBRuLe
- Excel as a document-oriented NoSQL database
- Excel 2010 Application.Caller Bug
- xLite Beta Updated – adds Python as an Excel Scripting Language
- Excel as the iPod of Downloaded Data
- TAG Cubes – SQLite Star Query Part III
- Palo HTTP API via Excel/VBA
-
Top Posts
- Python the new VBA ?
- JavaScript as an Excel scripting language via JSDB
- Like Excel macros? You'll love this..
- Star Schemas - to boldly go where no Excel spreadsheet has gone before
- xLITE - Excel/Proto SQLite utility
- SQLite - the ultimate data-smithing tool!
- Power (Pivot) to the People
- SQLite as the MP3 of data
- Talend vs. Kettle (Pentaho PDI)
- SQLite Star Query
-
Top Clicks
Category Cloud
Archives
- August 2010
- July 2010
- June 2010
- May 2010
- March 2010
- February 2010
- October 2009
- September 2009
- June 2009
- April 2009
- March 2009
- February 2009
- December 2008
- November 2008
- October 2008
- September 2008
- August 2008
- July 2008
- June 2008
- May 2008
- April 2008
- March 2008
- February 2008
- January 2008
- December 2007
- November 2007
- October 2007
- September 2007
- August 2007
- July 2007
- June 2007
- May 2007
- April 2007
- March 2007
- February 2007
- January 2007
- December 2006
- November 2006
- October 2006
- September 2006
- August 2006
- July 2006
- June 2006
- May 2006
- April 2006
- February 2006
