Quicken Data File Link

Is there a method to directly Link Quicken Data File to a Microsoft Access Database?
In other words, can Microsoft Access Database read the format of a quicken Data File..
My method:
1) Open Saved Quicken Report including all available Fields.
2) Copy/Paste Report in Excel Master worksheet with formula's that fill Split Transaction fields, that are not repeated in quicken report, i.e. Date, Account, Num, & Description.
3) Save Excel file to 'Data only' file. No Formulas
4) Open MS Access
5) Run Saved Macro to Import Quicken data from Excel to Table named i.e. "Quicken"
Tagged:

Comments

  • Sherlock
    Sherlock Quicken Windows Subscription Member ✭✭✭✭
    Microsoft Access cannot directly read a Quicken file.
This discussion has been closed.