AutoCAD Map 3D General Discussion

Reply
Contributor
DiegoP1978
Posts: 11
Registered: ‎07-24-2012
Message 1 of 8 (231 Views)

database

231 Views, 7 Replies
12-18-2012 06:29 AM

Hello everybody,

 

i'm trying to add a database (excel ) as source for object in Map3D.

i start but when i select the excel file that i've created and stored in my pc map3d says that the cration of the data source doesn't work.

Is anyone able to help me?

 

thx

 

Diego

*Expert Elite*
antoniovinci
Posts: 1,595
Registered: ‎06-03-2011
Message 2 of 8 (221 Views)

Re: database

12-18-2012 09:44 AM in reply to: DiegoP1978

Prima rispondi a questa, una alla volta...

*Expert Elite*
Murph
Posts: 1,932
Registered: ‎11-13-2006
Message 3 of 8 (204 Views)

Re: database

12-18-2012 03:26 PM in reply to: DiegoP1978

DiegoP1978 wrote:

Hello everybody,

 

i'm trying to add a database (excel ) as source for object in Map3D.

i start but when i select the excel file that i've created and stored in my pc map3d says that the cration of the data source doesn't work.

Is anyone able to help me?

 

thx

 

Diego


What version of Map3D and what OS are you using? 32 or 64 bit? Have you created an ODBC connection to the Excel file?

Murph
Supportting the troops daily.
Contributor
DiegoP1978
Posts: 11
Registered: ‎07-24-2012
Message 4 of 8 (195 Views)

Re: database

12-18-2012 11:24 PM in reply to: Murph

Hello,

 

thx for reply.

 

my Map3D version is 2013. The OS is windows 7 64 bit.

I don't have created an ODBC connection to the Excel file. I'm a rookie for Map3d trying to learn to use it because for my job is important to learn how to use a GIS manage charts and add information or keep information from it.

 

thx for reply

 

Diego

*Expert Elite*
antoniovinci
Posts: 1,595
Registered: ‎06-03-2011
Message 5 of 8 (191 Views)

Re: database

12-19-2012 01:19 AM in reply to: DiegoP1978

In my Map2006, it works according the attached ODBC setup: try with my example DWG/XLS (se non capisci qualcosa, scrivimi in privato).

Contributor
DiegoP1978
Posts: 11
Registered: ‎07-24-2012
Message 6 of 8 (186 Views)

Re: database

12-19-2012 04:37 AM in reply to: antoniovinci

Hello,

 

thx to reply.

 

I try to set the connection using the files you attached to your previous email. Doesn't work.

The screenshots are a little different maybe for the version and maybe because on my pc i don't have this Microsoft jet 4.0 ole db provider (see screenshot 2)

I attach an exemple of what i try to do.

 

1. i give a name to the connection

2. i select the  MS ole db provider for odbc drivers ( but i'm not sure it's right)

3. here i can set the source of my db ( Excel file)

4. here i set readwrite

5. here is the resume of the connection

6. After this i lunch the plugin for the connection i browse to the folder where i stored my Excel file but here appears this warning.

 

 

thx

Diego

*Expert Elite*
Murph
Posts: 1,932
Registered: ‎11-13-2006
Message 7 of 8 (170 Views)

Re: database

12-20-2012 03:09 PM in reply to: DiegoP1978
Contributor
DiegoP1978
Posts: 11
Registered: ‎07-24-2012
Message 8 of 8 (164 Views)

Re: database

12-20-2012 11:23 PM in reply to: Murph

Hello everybody.

 

Thank you for your help.

I understand that is a problem of drivers.

I make a research on web and i see that now there is a new driver for windows 7 64bit and i will soon try to install it and to use it to import excel files into map3d.

I'll post news very soon.

 

Thank to all that give me help.

 

Good last day on earth...

 

Bye

 

 

You are not logged in.

Log into access your profile, ask and answer questions, share ideas and more. Haven't signed up yet? Register

Announcements
Are you familiar with the Autodesk Expert Elites? The Expert Elite program is made up of customers that help other customers by sharing knowledge and exemplifying an engaging style of collaboration. To learn more, please visit our Expert Elite website.

Need installation help?

Start with some of our most frequented solutions to get help installing your software.

Ask the Community