AutoCAD Map 3D Forum
Welcome to Autodesk’s AutoCAD Map 3D Forums. Share your knowledge, ask questions, and explore popular AutoCAD Map 3D topics.
cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 

Map3D - MS Excel 64bit

2 REPLIES 2
SOLVED
Reply
Message 1 of 3
thepworth
825 Views, 2 Replies

Map3D - MS Excel 64bit

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!

Tags (1)
2 REPLIES 2
Message 2 of 3
phil_borycens
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
Message 3 of 3
FredTomke
in reply to: thepworth

Your PDF saved my life!
Regards, Fred

Can't find what you're looking for? Ask the community or share your knowledge.

Post to forums  

Autodesk Design & Make Report

”Boost