Connecting Shapefile to MS Access database

2 Messages Forum Options Options
Embed this topic
Permalink
Schultz, Gary T - COMMERCE
Connecting Shapefile to MS Access database
Reply Threaded MoreMore options
Print post
Permalink
Some javascript/style in this post has been disabled (why?)
I'm new to uDIG. Great application. We are looking as a tool to use along side ArcGIS and maybe someday as a possible replacement to ArcGIS.
 
Is it possible to connect a shapefile to an MS Access database tables as can be done in ArcGIS, in order to use the attributes from the Access tables? Can you connect to a dbf file? Or is it possible to connect the shapefile to an ODBC datasource?
 
Thanks in advance for any information provided.

Gary T. Schultz
Web Administrator
Wisconsin Department of Commerce
608-266-1283
gary.schultz@wi.gov


_______________________________________________
udig-users mailing list
udig-users@...
http://lists.refractions.net/mailman/listinfo/udig-users
Paul Ramsey
Re: Connecting Shapefile to MS Access database
Reply Threaded MoreMore options
Print post
Permalink
In the language of databases, to "do a join" between a shape file and
a another source of record information.

Short answer: no. Interim answer: move your data into a real RDBMS
(PostGIS, Oracle) and do the join in SQL, or as a view and connect to
it there.

Final answer: eventually, and particularly if someone funds that
development, as it is a core piece of desktop GIS functionality, but
not at the moment.

P.

On Mon, Jul 28, 2008 at 9:57 AM, Schultz, Gary T - COMMERCE
<Gary.Schultz@...> wrote:

> I'm new to uDIG. Great application. We are looking as a tool to use along
> side ArcGIS and maybe someday as a possible replacement to ArcGIS.
>
> Is it possible to connect a shapefile to an MS Access database tables as can
> be done in ArcGIS, in order to use the attributes from the Access tables?
> Can you connect to a dbf file? Or is it possible to connect the shapefile to
> an ODBC datasource?
>
> Thanks in advance for any information provided.
>
> Gary T. Schultz
> Web Administrator
> Wisconsin Department of Commerce
> 608-266-1283
> gary.schultz@...
>
> _______________________________________________
> udig-users mailing list
> udig-users@...
> http://lists.refractions.net/mailman/listinfo/udig-users
>
>
_______________________________________________
udig-users mailing list
udig-users@...
http://lists.refractions.net/mailman/listinfo/udig-users