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

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!
SOTAAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

PatHartmanCommented:
This is code from an old app.
Private Sub cmdGoogle_Click()
 'Opens Google Maps with the location "pinned"
 Dim strLocation As String
 Dim strTemp As String
     strLocation = Me.txtaddress & "+" & Me.cboTownCD.Column(1) & "+" & Me.cbostate & "+" & Me.cbozip
     strTemp = "http://maps.google.com/maps?q=" & strLocation
     Application.FollowHyperlink strTemp
End Sub

Open in new window

0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
SOTAAuthor Commented:
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

Open in new window

0
SOTAAuthor Commented:
Oh, how do I accept your answer? Experts-Exchange keeps changing their website!
0
SOTAAuthor Commented:
Figured it out! Thanks for your help!!!
0
PatHartmanCommented:
You're welcome.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Google

From novice to tech pro — start learning today.