Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
How can I export all my data from QB DT in a format that I can import in SQL (Dynamics GP)
Solved! Go to Solution.
Thanks for taking the time to scour our Community space for potential solutions, jaapkrijger.
In QuickBooks Desktop, we can import the data using CSV files which are simple text files containing tabular data. Each field in the file is separated from the next by a comma. Most spreadsheets support this format, however, you can create and edit CSV files with any text editor like Notepad. To learn more about other data types you can import and export to and from QuickBooks Desktop, check out this article: Import/export overview.
Then, follow the next steps in this article to finish the process: Import/export CSV files. To import the data in SQL (Dynamics GP), it would be best to contact their technical support agent. They'll provide you with details on how to do it on their end.
Feel free to browse this link here if you need help with other tasks in QuickBooks. It'll route you to our general topics with articles on managing your business.
Keep in touch if you need any more assistance with this, or there's something else I can do for you. I've got your back. Take care always.
You can utilize an exporter tool to get CVS files
https://transactionpro.grsm.io/qbd
Another option, purchase a 3rd party service to convert your data to MS Dynamics.
Thanks for taking the time to scour our Community space for potential solutions, jaapkrijger.
In QuickBooks Desktop, we can import the data using CSV files which are simple text files containing tabular data. Each field in the file is separated from the next by a comma. Most spreadsheets support this format, however, you can create and edit CSV files with any text editor like Notepad. To learn more about other data types you can import and export to and from QuickBooks Desktop, check out this article: Import/export overview.
Then, follow the next steps in this article to finish the process: Import/export CSV files. To import the data in SQL (Dynamics GP), it would be best to contact their technical support agent. They'll provide you with details on how to do it on their end.
Feel free to browse this link here if you need help with other tasks in QuickBooks. It'll route you to our general topics with articles on managing your business.
Keep in touch if you need any more assistance with this, or there's something else I can do for you. I've got your back. Take care always.
You have clicked a link to a site outside of the QuickBooks or ProFile Communities. By clicking "Continue", you will leave the community and be taken to that site instead.