Populate A SQL DB With Data? Excuse my ignorance

[NilsC 0]

What can I use for a frontend to populate a SQL db. I have a lot of the data and records on Access db and I'm looking for an easy way to load that data into the SQL db.The second issue are updating the SQL db with new records added to the Access db. New records added to a table in Access are marked for web publishing and should be moved to the SQL db in real time or close to real time and the record should be added to the correct index on the website so visitors can see / search for the update.The real life problem are:1 need listing of all horser and where they are stabled, locations are in different states and can be off site (at other companies stables)2 what horses are in training or on race schedule. Where are they racing next, history of prior races, trainer(s), grooms, statistics.3 what mares are in foal, who is the sire, when are they due, history of prior foals.4 new foals, picture, date born, sire/dam, scheduled for sale (if scheduled), where is the auction, price when sold to, sold to what stable / syndicate.All the data I'm going to use are on Access and will be updated in access.There are a lot of other issues but this is the framework I'm working on now. The users entering data into the Access db are located in different states, towns etc. Is there a way to setup webaccess to off site users entering data into the SQL db and I can then verify new data, and update the Access db with new data from the SQL db. This would then eliminate the step of transfering new data across the Internet to the Access db. Now the users have to connect using VPN and put a copy of the file on that server I have to verify the data and append it to the working (Main db) At the same time they get new data that was updated in other towns loaded onto their db. The problem now are data are not synchronized, and even when updated there is always a lag of 24 to 48 hours before everyone are on the same page.Thanks for any suggestions.Nils

[whafizi 0]

populate sql db with data? i did it once, but i forget already. this is what i can tell you;

you need to install ODBC support for that SQL db, then create a new DSN for that db in the DataSource(ODBC). open mS access and create a new project. set it to use that DSN. then, try to search for import/export. it can be used to take data from other sources, including access files. i cannot be really detailed here, cause i already forget. go play around!

secondly, i think you need a centralized data management, such as using webservers.

that way, you can have other users (authentication users) to add data about those horser. the idea is like this, create a field named as "verified". each time users input new data, the system will automatically give this field the value of "false". so, what you got to do, is only to change the value of that field to true, not to copy it again and again.

what do you think?

EDITED:
i've just found out a very useful software for you. it can populate access data to mysql. this is the link;

http://www.mdbtomysql.de/

hope it will be helpful.