AutoCAD Map 3D General Discussion

AutoCAD Map 3D General Discussion

Reply
Contributor
11 Posts
2 Kudos
Registered: ‎07-24-2012
Post 1 of 8

database

247 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*
1,795 Posts
194 Kudos
Registered: ‎06-03-2011
Post 2 of 8

Re: database

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

Prima rispondi a questa, una alla volta...

*Expert Elite*
2,141 Posts
207 Kudos
Registered: ‎11-13-2006
Post 3 of 8

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
11 Posts
2 Kudos
Registered: ‎07-24-2012
Post 4 of 8

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*
1,795 Posts
194 Kudos
Registered: ‎06-03-2011
Post 5 of 8

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
11 Posts
2 Kudos
Registered: ‎07-24-2012
Post 6 of 8

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*
2,141 Posts
207 Kudos
Registered: ‎11-13-2006
Post 7 of 8

Re: database

12-20-2012 03:09 PM in reply to: DiegoP1978
Contributor
11 Posts
2 Kudos
Registered: ‎07-24-2012
Post 8 of 8

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

 

 

Post to the Community

Have questions about Autodesk products? Ask the community.

New Post
Announcements
Are you interested in helping shape the future of the Autodesk Community? To participate in this brief usability study, please click here. Your time and input is greatly appreciated!