We’ve recently launched a website that has a database search function. Users can search our database to find company details etc. Short of having to input each and every companies details in by hand, is there any other way to populate a database with content? Obviously a database is more useful the more data it has. But to input the names and contact details of thousands of companies could take quite a while. Is there a faster way of doing this? Perhaps some software that we can use? Help!

We’ve recently launched a website that has a database search function. Users can search our database to find company details etc. Short of having to input each and every companies details in by hand, is there any other way to populate a database with content? Obviously a database is more useful the more data it has. But to input the names and contact details of thousands of companies could take quite a while. Is there a faster way of doing this? Perhaps some software that we can use? Help!

 

Depends on what previous format you have the data stored as and what server side pogramming you have and if your using mysql. If for instants you have it on Microsoft excel sheet there are programs/scripts out there that can turn them into sql dump files (i believe).

 

http://www.sqlconverter.com/excel.html