Skip to content

Tag Archives: spreadsheet

What is the fastest way to move large amounts of data from an Access database to an Excel chart?

Sunday, March 7, 2010

So far the fastest way I’ve found it to open an ADO recordset, save it as XML, and then open the XML file in Excel. I think it would probably be even faster to go from Access to text file (maybe CSV) then open that in Excel. But I’m not sure how to quickly go [...]

Filed in Q&A | Also tagged , , , | Comments (346)

How do I get OpenOffice documents to open in Microsoft Office?

Saturday, March 6, 2010

I have an OpenOffice spreadsheet that I want to open with microsoft office excel as well as an OpenOffice word that I want to open with microsoft word. Is there an extension program that I can download for MS office to open all other formats (.ODT and .XML) Thanks.

Filed in Q&A | Also tagged , , , , | Comments (257)

Does Excel 97 have the capability to read XML/HTML?

Thursday, March 4, 2010

I’m setting up a reporting function for something at work and I would like it output an Excel compatible file. I know that Excel 2003 has the ability to open a HTML file and display it as a spreadsheet but I’m unsure about Excel 97, which the end users are unfortunately stuck using. Note: I [...]

Filed in Q&A | Also tagged , , , , | Comments (63)

How can I parse an embedded XML data within e-mail to a database/spreadsheet?

Thursday, December 17, 2009

I receive an e-mail from a lead generation source. The xml content is embedded within the file. Is there an automated way I can strip the data from the e-mail and put it into a database or spreadsheet?

Filed in Q&A | Also tagged , , , | Comments (4)