Community Homepage
Discussions
Categories
Quicken for Mac
Quicken Lifehub
Quicken Mobile
Quicken on the Web
Quicken for Windows
Support
Quicken Classic
Quicken Simplifi
Getting Started
Community Training FAQs
Using and Improving the Community
Connect and Engage
Announcements & Alerts
Announcements
Alerts, Online Banking & Known Product Issues
Product Ideas
Beta
Home
Quicken Classic for Windows
Budgeting and Planning Tools (Windows)
Quicken Data File Link
Orig User
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"
Find more posts tagged with
File Conversion
Comments
Sherlock
Microsoft Access cannot directly read a Quicken file.
Quick Links
All Categories
Recent Posts
Activity
Unanswered
Best Of