Quicken Data File Link

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.
Categories
- All Categories
- 3 Product Ideas
- 27 Announcements
- 201 Alerts, Online Banking & Known Product Issues
- 20 Product Alerts
- 736 Welcome to the Community!
- 613 Before you Buy
- 1.1K Product Ideas
- 50.2K Quicken Classic for Windows
- 15.5K Quicken Classic for Mac
- 988 Quicken Mobile
- 781 Quicken on the Web
- 75 Quicken LifeHub