AutoCAD Map 3D General

Reply
*Terry Scanlon
Message 1 of 18 (1,466 Views)

ODBC Connectoin (Excel, Access)

1466 Views, 17 Replies
12-12-2008 01:20 PM
Documentation for Map really sucks sometimes. I have spent a
ridiculous amount of time trying to accomplish something that should
be fairly simple.

One task was to establish an ODBC connection so that I could perform a
join. I had a lot of trouble, I searched: help, support, discussion
groups, and google.

Support did end up solving my problem trying to get the connection in
Access. It was:

Points from ODBC data source do not display in Autodesk Map® 3D
Published date: 2006-Jun-22
ID: TS1058108
Applies to:
Autodesk Map® 3D 2007
Issue
You have a Microsoft Access .mdb table that contains x and y values
that you want to display as points in Autodesk Map® 3D using the FDO
ODBC Provider. You were able to connect to the ODBC data source and
specify the required x/y columns in the Data Connect dialog box.
However, when you added data to the map, no point objects could be
found in the drawing even though the point layer appeared in the Task
pane of the Display Manager.
Solution
To display points from an ODBC table in Autodesk Map® 3D, the table
needs to have a primary key field defined in MS Access. This primary
key can be generated automatically or manually.

However, I have not been able to establish a successful Excel
connection. I get the table, but it is empty. I see this question a
few other places in the discussion group, but no solution has worked.
I thought "Cannot see contents of Microsoft® Excel spreadsheet in
Project Workspace" ID: TS34004 might do the trick, but it did not. I
am testing with a very simple worksheet. I do have the named cell
range. I have tried the extra rows cited in the mentioned support
document.

Terry S
Distinguished Contributor
JohnPM
Posts: 657
Registered: ‎04-29-2007
Message 2 of 18 (1,466 Views)

Re: ODBC Connectoin (Excel, Access)

12-12-2008 02:35 PM in reply to: *Terry Scanlon
Try this in the connection string and see if it works. Driver={Microsoft Excel Driver (*.xls, *.xlsx, *.xlsm, *.xlsb)};DBQ=path\file.xlsx

path is the absolute path of the source of your file. I am assuming you are using 2007



John
*Murph
Message 3 of 18 (1,466 Views)

Re: ODBC Connectoin (Excel, Access)

12-12-2008 05:18 PM in reply to: *Terry Scanlon
Terry,
Is the Excel you using from Office 2007?

--
Murph
www.map3d.wordpress.com


"Terry Scanlon" wrote in message
news:6089361@discussion.autodesk.com...
Documentation for Map really sucks sometimes. I have spent a
ridiculous amount of time trying to accomplish something that should
be fairly simple.

One task was to establish an ODBC connection so that I could perform a
join. I had a lot of trouble, I searched: help, support, discussion
groups, and google.

Support did end up solving my problem trying to get the connection in
Access. It was:

Points from ODBC data source do not display in Autodesk Map® 3D
Published date: 2006-Jun-22
ID: TS1058108
Applies to:
Autodesk Map® 3D 2007
Issue
You have a Microsoft Access .mdb table that contains x and y values
that you want to display as points in Autodesk Map® 3D using the FDO
ODBC Provider. You were able to connect to the ODBC data source and
specify the required x/y columns in the Data Connect dialog box.
However, when you added data to the map, no point objects could be
found in the drawing even though the point layer appeared in the Task
pane of the Display Manager.
Solution
To display points from an ODBC table in Autodesk Map® 3D, the table
needs to have a primary key field defined in MS Access. This primary
key can be generated automatically or manually.

However, I have not been able to establish a successful Excel
connection. I get the table, but it is empty. I see this question a
few other places in the discussion group, but no solution has worked.
I thought "Cannot see contents of Microsoft® Excel spreadsheet in
Project Workspace" ID: TS34004 might do the trick, but it did not. I
am testing with a very simple worksheet. I do have the named cell
range. I have tried the extra rows cited in the mentioned support
document.

Terry S
*Terry Scanlon
Message 4 of 18 (1,466 Views)

Re: ODBC Connectoin (Excel, Access)

12-15-2008 10:58 AM in reply to: *Terry Scanlon
Sorry for the lack of info, folks. This is Map 3d 2008 and Excel
2003.

Murph wrote:
> Terry,
> Is the Excel you using from Office 2007?
>
> --
> Murph
> www.map3d.wordpress.com
>
>
> "Terry Scanlon" wrote in message
> news:6089361@discussion.autodesk.com...
> Documentation for Map really sucks sometimes. I have spent a
> ridiculous amount of time trying to accomplish something that should
> be fairly simple.
>
> One task was to establish an ODBC connection so that I could perform
> a
> join. I had a lot of trouble, I searched: help, support, discussion
> groups, and google.
>
> Support did end up solving my problem trying to get the connection
> in
> Access. It was:
>
> Points from ODBC data source do not display in Autodesk Map® 3D
> Published date: 2006-Jun-22
> ID: TS1058108
> Applies to:
> Autodesk Map® 3D 2007
> Issue
> You have a Microsoft Access .mdb table that contains x and y values
> that you want to display as points in Autodesk Map® 3D using the FDO
> ODBC Provider. You were able to connect to the ODBC data source and
> specify the required x/y columns in the Data Connect dialog box.
> However, when you added data to the map, no point objects could be
> found in the drawing even though the point layer appeared in the
> Task
> pane of the Display Manager.
> Solution
> To display points from an ODBC table in Autodesk Map® 3D, the table
> needs to have a primary key field defined in MS Access. This primary
> key can be generated automatically or manually.
>
> However, I have not been able to establish a successful Excel
> connection. I get the table, but it is empty. I see this question
> a
> few other places in the discussion group, but no solution has
> worked.
> I thought "Cannot see contents of Microsoft® Excel spreadsheet in
> Project Workspace" ID: TS34004 might do the trick, but it did not.
> I
> am testing with a very simple worksheet. I do have the named cell
> range. I have tried the extra rows cited in the mentioned support
> document.
>
> Terry S
*Terry Scanlon
Message 5 of 18 (1,466 Views)

Re: ODBC Connectoin (Excel, Access)

12-15-2008 11:04 AM in reply to: *Terry Scanlon
JohnPM wrote:
> Try this in the connection string and see if it works.
> Driver={Microsoft Excel Driver (*.xls, *.xlsx, *.xlsm,
> *.xlsb)};DBQ=path\file.xlsx path is the absolute path of the source
> of your file. I am assuming you are using 2007 John

Sorry for lack of info: I'm running Map 08 and Excel 2003.

I tried the path, and can't even get a connect. With the DSN method,
I get a connect...just no data.
*Murph
Message 6 of 18 (1,466 Views)

Re: ODBC Connectoin (Excel, Access)

12-15-2008 03:00 PM in reply to: *Terry Scanlon
Ok no problem.
When you connect to your name cell ranges in the FDO are you selecting the
columns for the x,y coordinates? You need to stretch the columns wider and
select the coulnm names for each.

Murph


"Terry Scanlon" wrote in message
news:6090204@discussion.autodesk.com...
Sorry for the lack of info, folks. This is Map 3d 2008 and Excel
2003.

Murph wrote:
> Terry,
> Is the Excel you using from Office 2007?
>
> --
> Murph
> www.map3d.wordpress.com
>
>
> "Terry Scanlon" wrote in message
> news:6089361@discussion.autodesk.com...
> Documentation for Map really sucks sometimes. I have spent a
> ridiculous amount of time trying to accomplish something that should
> be fairly simple.
>
> One task was to establish an ODBC connection so that I could perform
> a
> join. I had a lot of trouble, I searched: help, support, discussion
> groups, and google.
>
> Support did end up solving my problem trying to get the connection
> in
> Access. It was:
>
> Points from ODBC data source do not display in Autodesk Map® 3D
> Published date: 2006-Jun-22
> ID: TS1058108
> Applies to:
> Autodesk Map® 3D 2007
> Issue
> You have a Microsoft Access .mdb table that contains x and y values
> that you want to display as points in Autodesk Map® 3D using the FDO
> ODBC Provider. You were able to connect to the ODBC data source and
> specify the required x/y columns in the Data Connect dialog box.
> However, when you added data to the map, no point objects could be
> found in the drawing even though the point layer appeared in the
> Task
> pane of the Display Manager.
> Solution
> To display points from an ODBC table in Autodesk Map® 3D, the table
> needs to have a primary key field defined in MS Access. This primary
> key can be generated automatically or manually.
>
> However, I have not been able to establish a successful Excel
> connection. I get the table, but it is empty. I see this question
> a
> few other places in the discussion group, but no solution has
> worked.
> I thought "Cannot see contents of Microsoft® Excel spreadsheet in
> Project Workspace" ID: TS34004 might do the trick, but it did not.
> I
> am testing with a very simple worksheet. I do have the named cell
> range. I have tried the extra rows cited in the mentioned support
> document.
>
> Terry S
*Terry Scanlon
Message 7 of 18 (1,466 Views)

Re: ODBC Connectoin (Excel, Access)

12-16-2008 06:34 AM in reply to: *Terry Scanlon
Hi Murph,

I had actaully read previous posts of yours where you mentioned this
and tried to do something similar to what you describe with no
results. This is actually an non-spatial table.

Here is an explanation of what I was trying to do:
I already have a connection to an SDF which includes a certain data
field (Soil Types)
I have a spreadsheet which correlates the soil type to hydrologic soil
groups A, B, C, or D. (non-spatial)
I wish to create a link between the data sets in order to map
hydrologic soil groups.

(I have actually accomplished this by bringing the Excel data into an
Access database and have succussfully used ODBC to connect to that
data source. I am just stuck on making this work with Excel as well.
Not everyone has Access. )

Terry

"Murph" wrote in message
news:6090444@discussion.autodesk.com...
Ok no problem.
When you connect to your name cell ranges in the FDO are you selecting
the
columns for the x,y coordinates? You need to stretch the columns wider
and
select the coulnm names for each.

Murph


"Terry Scanlon" wrote in message
news:6090204@discussion.autodesk.com...
Sorry for the lack of info, folks. This is Map 3d 2008 and Excel
2003.

Murph wrote:
> Terry,
> Is the Excel you using from Office 2007?
>
> --
> Murph
> www.map3d.wordpress.com
>
>
> "Terry Scanlon" wrote in message
> news:6089361@discussion.autodesk.com...
> Documentation for Map really sucks sometimes. I have spent a
> ridiculous amount of time trying to accomplish something that should
> be fairly simple.
>
> One task was to establish an ODBC connection so that I could perform
> a
> join. I had a lot of trouble, I searched: help, support, discussion
> groups, and google.
>
> Support did end up solving my problem trying to get the connection
> in
> Access. It was:
>
> Points from ODBC data source do not display in Autodesk Map® 3D
> Published date: 2006-Jun-22
> ID: TS1058108
> Applies to:
> Autodesk Map® 3D 2007
> Issue
> You have a Microsoft Access .mdb table that contains x and y values
> that you want to display as points in Autodesk Map® 3D using the FDO
> ODBC Provider. You were able to connect to the ODBC data source and
> specify the required x/y columns in the Data Connect dialog box.
> However, when you added data to the map, no point objects could be
> found in the drawing even though the point layer appeared in the
> Task
> pane of the Display Manager.
> Solution
> To display points from an ODBC table in Autodesk Map® 3D, the table
> needs to have a primary key field defined in MS Access. This primary
> key can be generated automatically or manually.
>
> However, I have not been able to establish a successful Excel
> connection. I get the table, but it is empty. I see this question
> a
> few other places in the discussion group, but no solution has
> worked.
> I thought "Cannot see contents of Microsoft® Excel spreadsheet in
> Project Workspace" ID: TS34004 might do the trick, but it did not.
> I
> am testing with a very simple worksheet. I do have the named cell
> range. I have tried the extra rows cited in the mentioned support
> document.
>
> Terry S
*Murph
Message 8 of 18 (1,466 Views)

Re: ODBC Connectoin (Excel, Access)

12-16-2008 09:52 AM in reply to: *Terry Scanlon
Ok Got ya,
I just tried this and get the same error on a simple speadsheet too, using
Map3D 2009 and Excel 2003.

Murph


"Terry Scanlon" wrote in message
news:6090754@discussion.autodesk.com...
Hi Murph,

I had actaully read previous posts of yours where you mentioned this
and tried to do something similar to what you describe with no
results. This is actually an non-spatial table.

Here is an explanation of what I was trying to do:
I already have a connection to an SDF which includes a certain data
field (Soil Types)
I have a spreadsheet which correlates the soil type to hydrologic soil
groups A, B, C, or D. (non-spatial)
I wish to create a link between the data sets in order to map
hydrologic soil groups.

(I have actually accomplished this by bringing the Excel data into an
Access database and have succussfully used ODBC to connect to that
data source. I am just stuck on making this work with Excel as well.
Not everyone has Access. )

Terry

"Murph" wrote in message
news:6090444@discussion.autodesk.com...
Ok no problem.
When you connect to your name cell ranges in the FDO are you selecting
the
columns for the x,y coordinates? You need to stretch the columns wider
and
select the coulnm names for each.

Murph


"Terry Scanlon" wrote in message
news:6090204@discussion.autodesk.com...
Sorry for the lack of info, folks. This is Map 3d 2008 and Excel
2003.

Murph wrote:
> Terry,
> Is the Excel you using from Office 2007?
>
> --
> Murph
> www.map3d.wordpress.com
>
>
> "Terry Scanlon" wrote in message
> news:6089361@discussion.autodesk.com...
> Documentation for Map really sucks sometimes. I have spent a
> ridiculous amount of time trying to accomplish something that should
> be fairly simple.
>
> One task was to establish an ODBC connection so that I could perform
> a
> join. I had a lot of trouble, I searched: help, support, discussion
> groups, and google.
>
> Support did end up solving my problem trying to get the connection
> in
> Access. It was:
>
> Points from ODBC data source do not display in Autodesk Map® 3D
> Published date: 2006-Jun-22
> ID: TS1058108
> Applies to:
> Autodesk Map® 3D 2007
> Issue
> You have a Microsoft Access .mdb table that contains x and y values
> that you want to display as points in Autodesk Map® 3D using the FDO
> ODBC Provider. You were able to connect to the ODBC data source and
> specify the required x/y columns in the Data Connect dialog box.
> However, when you added data to the map, no point objects could be
> found in the drawing even though the point layer appeared in the
> Task
> pane of the Display Manager.
> Solution
> To display points from an ODBC table in Autodesk Map® 3D, the table
> needs to have a primary key field defined in MS Access. This primary
> key can be generated automatically or manually.
>
> However, I have not been able to establish a successful Excel
> connection. I get the table, but it is empty. I see this question
> a
> few other places in the discussion group, but no solution has
> worked.
> I thought "Cannot see contents of Microsoft® Excel spreadsheet in
> Project Workspace" ID: TS34004 might do the trick, but it did not.
> I
> am testing with a very simple worksheet. I do have the named cell
> range. I have tried the extra rows cited in the mentioned support
> document.
>
> Terry S
Active Contributor
ckrismer
Posts: 31
Registered: ‎01-15-2010
Message 9 of 18 (1,455 Views)

Re: ODBC Connection (Excel, Access)

08-10-2010 08:41 AM in reply to: *Terry Scanlon

I have a mdb file that I am trying to connect to.  I am a newbie.  When I choose the headers for the x and y columns, I don't know what to select.  The available headings include such items as FOREST_ID, HECTARES, etc.  Adding headers at random brings features into the map, but not the correct shapes.  (Using connect to data / add ODBC).  I appreciate any help offered.

*Expert Elite*
Murph
Posts: 1,921
Registered: ‎11-13-2006
Message 10 of 18 (1,452 Views)

Re: ODBC Connection (Excel, Access)

08-10-2010 08:50 AM in reply to: ckrismer

The shapes displayed are the default you need to style them after you add the features to the map. As for the X-Y column use the columns that have the X corrdinate and Y coordinate.

Murph
Supportting the troops daily.

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