Quicken Data File Link
Options
Orig User
Member ✭✭
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"
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:
0
Comments
-
Microsoft Access cannot directly read a Quicken file.0
This discussion has been closed.