<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=us-ascii">
<META content="MSHTML 6.00.6000.16481" name=GENERATOR>
<STYLE>@font-face {
font-family: Calibri;
}
@page Section1 {size: 612.0pt 792.0pt; margin: 72.0pt 72.0pt 72.0pt 72.0pt; }
P.MsoNormal {
FONT-SIZE: 11pt; MARGIN: 0cm 0cm 0pt; FONT-FAMILY: "Calibri","sans-serif"
}
LI.MsoNormal {
FONT-SIZE: 11pt; MARGIN: 0cm 0cm 0pt; FONT-FAMILY: "Calibri","sans-serif"
}
DIV.MsoNormal {
FONT-SIZE: 11pt; MARGIN: 0cm 0cm 0pt; FONT-FAMILY: "Calibri","sans-serif"
}
A:link {
COLOR: blue; TEXT-DECORATION: underline; mso-style-priority: 99
}
SPAN.MsoHyperlink {
COLOR: blue; TEXT-DECORATION: underline; mso-style-priority: 99
}
A:visited {
COLOR: purple; TEXT-DECORATION: underline; mso-style-priority: 99
}
SPAN.MsoHyperlinkFollowed {
COLOR: purple; TEXT-DECORATION: underline; mso-style-priority: 99
}
SPAN.EmailStyle17 {
COLOR: windowtext; FONT-FAMILY: "Calibri","sans-serif"; mso-style-type: personal-compose
}
.MsoChpDefault {
mso-style-type: export-only
}
DIV.Section1 {
page: Section1
}
</STYLE>
<!--[if gte mso 9]><xml>
<o:shapedefaults spidmax="1026" v:ext="edit">
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap data="1" v:ext="edit">
</o:shapelayout></xml><![endif]--></HEAD>
<BODY>
<DIV dir=ltr align=left><SPAN class=453555510-12052008><FONT face=Arial
color=#0000ff size=2>James,</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=453555510-12052008><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=453555510-12052008><FONT face=Arial
color=#0000ff size=2>Depends what you are doing. We have been using
mostly Access 2003/2000, but I presume it works just as well with Access
2007. </FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=453555510-12052008><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=453555510-12052008><FONT face=Arial
color=#0000ff size=2>You can migrate the tables by doing simple export table
individually to a PostgreSQL ODBC source or use Ogr2OGr to do a bulk multi-table
dump</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=453555510-12052008><FONT face=Arial
color=#0000ff size=2>and just drop the geometry table it creates for each
table. Then just relink the tables as linked tables.</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=453555510-12052008><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=453555510-12052008><FONT face=Arial
color=#0000ff size=2>You can rewrite the queries as views or just keep them as
queries.</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=453555510-12052008><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=453555510-12052008><FONT face=Arial
color=#0000ff size=2>Reports can not be exported because they aren't really
database objects as far as PostgreSQL and SQL Server are
concerned.</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=453555510-12052008><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=453555510-12052008><FONT face=Arial
color=#0000ff size=2>Many of our applications have MS Access as the front
end and PostgreSQL or SQL Server or combination of both as the back end and
its a fairly nice combination. If you don't have any qualms with keeping
your Access front-end, that tends to be</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=453555510-12052008><FONT face=Arial
color=#0000ff size=2>the easiest route to go.</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=453555510-12052008><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=453555510-12052008><FONT face=Arial
color=#0000ff size=2>Below is are some articles you may find useful that
covers some gotchas and load examples</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=453555510-12052008><FONT face=Arial
color=#0000ff size=2><A
href="http://www.postgresonline.com/journal/index.php?/archives/24-Using-MS-Access-with-PostgreSQL.html">http://www.postgresonline.com/journal/index.php?/archives/24-Using-MS-Access-with-PostgreSQL.html</A></FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=453555510-12052008><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=453555510-12052008><FONT face=Arial
color=#0000ff size=2><A
href="http://www.postgresonline.com/journal/index.php?/archives/31-GDAL-OGR2OGR-for-Data-Loading.html">http://www.postgresonline.com/journal/index.php?/archives/31-GDAL-OGR2OGR-for-Data-Loading.html</A></FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=453555510-12052008><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=453555510-12052008><FONT face=Arial
color=#0000ff size=2>Unfortunately using PostGIS from within MS Access is a
little trickier. For simple spatial queries - e.g. distance queries that
just return attribute data, I use MS Access pass-thru
queries.</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=453555510-12052008><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=453555510-12052008><FONT face=Arial
color=#0000ff size=2>There is also MapWindow if you need to display maps -
but haven't had much success getting it to work last I tried which was about a
year or so ago. The PostGIS driver for it still seems very low alpha
quality, but it may be worth a try if</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=453555510-12052008><FONT face=Arial
color=#0000ff size=2>you need to show your maps from within MS
Access.</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=453555510-12052008><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=453555510-12052008><FONT face=Arial
color=#0000ff size=2><A
href="http://www.mapwindow.org">http://www.mapwindow.org</A></FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=453555510-12052008><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=453555510-12052008><FONT face=Arial
color=#0000ff size=2>Hope that helps,</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=453555510-12052008><FONT face=Arial
color=#0000ff size=2>Regina</FONT></SPAN></DIV><BR>
<DIV class=OutlookMessageHeader lang=en-us dir=ltr align=left>
<HR tabIndex=-1>
<FONT face=Tahoma size=2><B>From:</B>
postgis-users-bounces@postgis.refractions.net
[mailto:postgis-users-bounces@postgis.refractions.net] <B>On Behalf Of </B>James
Stott<BR><B>Sent:</B> Monday, May 12, 2008 6:14 AM<BR><B>To:</B>
postgis-users@postgis.refractions.net<BR><B>Subject:</B> [postgis-users] MS
Access to PostgreSQL<BR></FONT><BR></DIV>
<DIV></DIV>
<DIV>
<DIV class=Section1>
<P class=MsoNormal><SPAN lang=EN-GB>Hi all,</SPAN><O:P></O:P></P>
<P class=MsoNormal style="MARGIN-LEFT: 36pt"><SPAN
lang=EN-GB></SPAN><O:P></O:P></P>
<P class=MsoNormal><SPAN lang=EN-GB>I am a bit of a newcomer to PostGIS and
wanted to ask a question.</SPAN><O:P></O:P></P>
<P class=MsoNormal style="MARGIN-LEFT: 36pt"><SPAN
lang=EN-GB></SPAN><O:P></O:P></P>
<P class=MsoNormal><SPAN lang=EN-GB>Is it possible to migrate a database from MS
Access into PostgreSQL? Can table structures, queries, rules, indexes and
reports be moved over easily or is it a case of having to recreate everything by
hand?</SPAN><O:P></O:P></P>
<P class=MsoNormal style="MARGIN-LEFT: 36pt"><SPAN
lang=EN-GB></SPAN><O:P></O:P></P>
<P class=MsoNormal><SPAN lang=EN-GB>I am using Access
2007.</SPAN><O:P></O:P></P>
<P class=MsoNormal style="MARGIN-LEFT: 36pt"><SPAN
lang=EN-GB></SPAN><O:P></O:P></P>
<P class=MsoNormal><SPAN lang=EN-GB>We would then like to extend the attribute
data by adding spatial information to the records as well.<O:P></O:P></SPAN></P>
<P class=MsoNormal><SPAN lang=EN-GB><O:P></O:P></SPAN></P>
<P class=MsoNormal><SPAN lang=EN-GB>Many thanks,</SPAN><O:P></O:P></P>
<P class=MsoNormal style="MARGIN-LEFT: 36pt"><SPAN
lang=EN-GB></SPAN><O:P></O:P></P>
<P class=MsoNormal><B><SPAN lang=EN-GB
style="FONT-SIZE: 10pt; FONT-FAMILY: 'Arial','sans-serif'">James</SPAN></B><O:P></O:P></P>
<P class=MsoNormal><O:P></O:P></P></DIV></DIV>
<DIV id=DISCLAIMER
style="FONT-SIZE: 10pt; FONT-FAMILY: Arial; TEXT-ALIGN: center; mso-ansi-language: EN-GB"
align=center><B>
<P>This Electronic Transmission is intended only for the attention of the
addressee. It may contain privileged and confidential information. If you are
not the person for whom it is intended, you must not copy, distribute or take
any action in reliance on it. If you have received this electronic transmission
in error please notify us immediately by telephone, delete the transmission and
destroy any hard copies. </P>
<P>Nicholas Pearson Associates has used all reasonable efforts to ensure that
this message and any attachments are free from viruses. </P>
<P><SPAN lang=EN-GB style="FONT-SIZE: 13.5pt">Nicholas Pearson Associates
</SPAN></P>
<P>Environmental Planners - Landscape Architects - Ecologists </P>
<P>30 Brock Street, Bath, BA1 2LN </P>
<P>Tel: +44 (0) 1225 445548, Fax: +44 (0) 1225 312387 </P>
<P><A href="http://www.npaconsult.co.uk/">www.npaconsult.co.uk
</A></P></B></DIV></BODY></HTML>
<HTML><BODY><P><hr size=1></P>
<P><STRONG>
The substance of this message, including any attachments, may be confidential, legally privileged and/or exempt from disclosure pursuant to Massachusetts law. It is intended solely for the addressee. If you received this in error, please contact the sender and delete the material from any computer.
</STRONG></P></BODY></HTML>
<P><hr size=1></P>
<P><STRONG><font size="2" color="339900"> Help make the earth a greener place. If at all possible resist printing this email and join us in saving paper. </p> <p> </font></STRONG></P>