Financial Software Questions? Ask IT Support for Answers ASAP
Welcome to JustAnswer! My name is ***** ***** I am happy to help you with the export using ODBC to MS Access.
I have not actually tried (or read anyone else do this) to pull raw data from Quicken using an ODBC driver. If I can spend an hour or so attempting different export options, I will let you know what worked. I will respond again soon!
Unfortunately, I was not able to setup a live ODBC connection with Quicken. I did create a transaction list from Quicken, Export to an Excel Compatible format (.txt) and open in MS Access using External Data Connection (.txt). I then could 'update' the transaction list with more data from Quicken by exporting another transaction list and then linking and importing this new list to the current .txt file in Access. It is still not 'clean' as you have totals but it is close.
If you are interested in the steps or need more information, please let me know.
Thank you for using JustAnswer!
If you tell me or send examples as to what report you need from Quicken, I will be happy to see if I can customize in Quicken for you.