• Industries
  • Products
  • Buy
  • Services & Support
  • Communities
  • AutoCAD Map 3D

    Reply
    Contributor
    Posts: 11
    Registered: ‎07-24-2012

    database

    153 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

    Please use plain text.
    *Expert Elite*
    antoniovinci
    Posts: 1,100
    Registered: ‎06-03-2011

    Re: database

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

    Prima rispondi a questa, una alla volta...

    Please use plain text.
    *Expert Elite*
    Murph
    Posts: 1,591
    Registered: ‎11-13-2006

    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.
    Please use plain text.
    Contributor
    Posts: 11
    Registered: ‎07-24-2012

    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

    Please use plain text.
    *Expert Elite*
    antoniovinci
    Posts: 1,100
    Registered: ‎06-03-2011

    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).

    Please use plain text.
    Contributor
    Posts: 11
    Registered: ‎07-24-2012

    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

    Please use plain text.
    *Expert Elite*
    Murph
    Posts: 1,591
    Registered: ‎11-13-2006

    Re: database

    12-20-2012 03:09 PM in reply to: DiegoP1978
    Please use plain text.
    Contributor
    Posts: 11
    Registered: ‎07-24-2012

    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

     

     

    Please use plain text.