AutoCAD Map 3D General Discussion

Reply
Distinguished Mentor
thepworth
Posts: 525
Registered: ‎03-02-2011
Message 1 of 2 (321 Views)
Accepted Solution

Map3D - MS Excel 64bit

321 Views, 1 Replies
03-13-2012 01:28 PM

O.K. so today I'm having yet another "brain fart"

 

I have a map with a .SDF attached.  I took the .SDF and copied/pasted into an Excel spreadsheet.  This was to do a mail-merge to request access to property to collect samples from multiple folks.  As I'm getting the responses in, I'd like my admin to update the responses & contact information we get back.  Seems logical as my admin knows Adobe Publishing, & barely knows the MS  Office suite.  Rather than confuse someone with my ineptitude with database forms, I thought a spreadsheet would be the way to go.  linking to Excel isn't my first choice, but...

 

I put the attached document together in 2010.  I can get as far as configuring & connecting to the data source, but then I get a red "X" through the connection on Map Explorer even though it tests successfully.  I went so far as to uninstall 32-bit MS office & download/install 64-bit (yup, the machine came pre-loaded with 32-bit - MS help actually took my call and had a link to a 64-bit download path to me within 8-minutes, so I was feeling pretty good until a few moments ago). 

 

Other than moving into MySQL, any thoughts as to why I can't connect or suggestions for what else I might try?

 

TIA!


C3D 2011
Intel Xeon E5630@2.53Ghz
NVIDA Quadro NVS420 Dual Monitor
12GB Ram / Win7 Professional 64bit SP1
Product Support
phil_borycens
Posts: 185
Registered: ‎10-25-2011
Message 2 of 2 (239 Views)

Re: Map3D - MS Excel 64bit

04-10-2012 02:11 PM in reply to: thepworth

AutoCAD Map 3D needs to know where in the workbook to look for the data -- so creating a named range (or in newer versions of Excel "Define Name") is required. Taking this step resolved the issue.



Phil Borycens

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