Quicken Community is moving to Single Sign On! Starting 1/22/21, you'll sign in to the community with your Quicken ID. For more information: http://bit.ly/CommunitySSO

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 SuperUser ✭✭✭✭✭
    Microsoft Access cannot directly read a Quicken file.
This discussion has been closed.