SOTA

<div>
Yea! I just implemented a similar approach! Google needs &quot;+&quot; between address elements, so I use a FindReplace to ensure proper parsing:<br />

<pre><code id="code-20-42520065-1">TargetURL = rs![Address1] &amp; &quot;+&quot; &amp; rs![Address2] &amp; &quot;+&quot; &amp; rs![City] &amp; &quot;+&quot; &amp; rs![Abbreviation] &amp; &quot;+&quot; &amp; rs![Country]
TargetURL = FindAndReplace(TargetURL, Chr(32), Chr(43))
TargetURL = &quot;https://www.google.com/maps/place/&quot; &amp; TargetURL</code></pre>
</div>


Yea! I just implemented a similar approach! Google needs "+" between address elements, so I use a FindReplace to ensure proper parsing:


TargetURL = rs![Address1] & "+" & rs![Address2] & "+" & rs![City] & "+" & rs![Abbreviation] & "+" & rs![Country]
TargetURL = FindAndReplace(TargetURL, Chr(32), Chr(43))
TargetURL = "https://www.google.com/maps/place/" & TargetURL

<div>
Oh, how do I accept your answer? Experts-Exchange keeps changing their website!
</div>


Oh, how do I accept your answer? Experts-Exchange keeps changing their website!

<div>
Figured it out! Thanks for your help!!!
</div>


<div>
<div class="content wysiwyg-content">
I have an Access 97 database with Customers. I wish to parse the address field into a URL that can be opened with Google Maps.<br />
Has anyone done this before so I do not have to re-invent the wheel?<br />
I see there are certain parameters to use in order for the URL to work properly.<br />
I have the addresses stored in SQL tables.<br />
<br />
Address1<br />
Address2<br />
Province/State<br />
City<br />
Zip/Postal Code<br />
Country<br />
<br />
Any suggestions please?<br />
Thanks!
</div>
</div>


I have an Access 97 database with Customers. I wish to parse the address field into a URL that can be opened with Google Maps.
Has anyone done this before so I do not have to re-invent the wheel?
I see there are certain parameters to use in order for the URL to work properly.
I have the addresses stored in SQL tables.

Address1
Address2
Province/State
City
Zip/Postal Code
Country

Any suggestions please?
Thanks!

How to parse a URL for Google Maps from SQL Address table

Google is an American multinational technology company specializing in Internet-related services and products that include online advertising technologies, search, cloud computing, software, and hardware.

Google

Databases are organized collections of data, most commonly accessed through management systems including schemas, tables, queries and processes that allow users to enter and manipulate the information or utilize it in other fashions, such as with web applications or for reporting purposes.

Databases

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.