topic Re: import data from microsoft access in AutoCAD Forum

import data from microsoft access

rigosvasilios — Wed, 03 Feb 2016 13:33:03 GMT

Hello community! I am not a programmer but there is a need to import data from an access database to autocad text (or label if possible) but i have no idea how to do it. I managed to do it through excel with data link but the idea is that i want to link a specific data from the table without loosing his place after i do some sorting and in excel dont know if it is possible. Thank you.

Re: import data from microsoft access

john.vellek — Thu, 07 Apr 2016 18:59:51 GMT

Hello @rigosvasilios

It is possible to connect your drawing to a MS Access database.Using the DBCONNECT command you can create an ODBC connection to your data. A windows ODBC DSN is configured and then you should be able to make the connection. Or, use the AccessDatabaseEngine_x64.exe to set up Windows for the connection.

Take a look at the AKN Article DBCONNECT

You might also find this Youtube video of interest Adding to AutoCAD Electrical Database with Microsoft Access

Please hit the Accept as Solution button if my post fully solves your issue or answers your question.

Re: import data from microsoft access

john.vellek — Tue, 05 Apr 2016 18:45:43 GMT

Hi @rigosvasilios,

I wanted to check in with you to see if you had any success in making the data connection with Microsoft Access to your AutoCAD drawing. Please let me know if you need additional information or resources.

Please hit the Accept as Solution button if my post fully solves your issue or answers your question.

Re: import data from microsoft access

john.vellek — Thu, 07 Apr 2016 19:00:48 GMT

Hi @rigosvasilios,
I’ve just accepted the response to your post (linked here) as a solution with the understanding that it is the correct answer.
If my response did not work as an answer, please reply to the previously linked thread so that I can unmark the solution, and we can continue the conversation.
No action is required if my response did work as an answer, however I wanted to point out that if the opportunity arises again you can also click on the ‘Accept as Solution’ button if/when relevant so that others can more easily benefit from the information. Please feel free to let me know if you have any questions or concerns!