Starting with Quicken 2005 Intuit dropped the QIF format for importing data.

For older versions of Quicken there is a $49 product that will convert an Excel spreadsheet into a QIF format.

Check out
http://www.bigredconsulting.com/AboutXLQIFConverter.htm