AutoCAD Map 3D General Discussion

AutoCAD Map 3D General Discussion

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

Map3D - MS Excel 64bit

330 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

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.

Product Support
phil_borycens
Posts: 192
Registered: ‎10-25-2011
Message 2 of 2 (248 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
Need installation help?

Start with some of our most frequented solutions or visit the Installation and Licensing Forum to get help installing your software.