Peeledpotato Posted May 27, 2014 Report Share Posted May 27, 2014 Dear Colleagues, My wife recently started working for a property broker as an intern. They have asked me to look at a database they have been building for the last couple of years. the database is in Access format and has a number of forms which they use to update the db. I have not worked with Access before as I am primarily a shapefile person who has a leaning towards spatialite. The db has a column referencing a well known local spatial data set so I should be able to map the data easily enough. However, they are looking for a system whereby I host the data online and update it from time to time. I was thinking about using google to host the db but am then going to need to convert the Access db to SQL / spatialite or something similar. I don't have access to ESRI products so am thinking of open source alternatives. Can anyone point me towards a tutorial dealing with converting access db's to an open source format and which if any of the online hosting services would you recommend? Many thanks and trust you are all well, P Quote Link to comment Share on other sites More sharing options...
muwla Posted May 27, 2014 Report Share Posted May 27, 2014 Mr. P, As for converting a db file to any spatial format use global mapper. many thanks, Mula Quote Link to comment Share on other sites More sharing options...
muwla Posted May 27, 2014 Report Share Posted May 27, 2014 FYI this work http://support.spatialkey.com/export-data-from-database-to-csv-file/ Quote Link to comment Share on other sites More sharing options...
darksabersan Posted May 27, 2014 Report Share Posted May 27, 2014 If I can add a new suggestion, I will proposed you to use PostgreSQL as free database. It allowed you to use a lot of various format file. Look around our forum to find articles and books concerning the topic. Don't hesitate to ask for more help. darksabersan. Quote Link to comment Share on other sites More sharing options...
Peeledpotato Posted May 27, 2014 Author Report Share Posted May 27, 2014 Thanks for the input. What I may do is simply convert the Accessdb to csv and work from there. Ideally I would like to host it online but I need to figure out how to do that first without having to pay an arm and a leg for hosting. Google is perhaps a good option. P Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.