Home » questions » Is there a program that can take information from various sources (text, doc) and compile it in a da

Is there a program that can take information from various sources (text, doc) and compile it in a da

5
2006-08-10 09:57:30, Category: Programming & Design
I'd like to find an existing program or have a program made that can take data from various sources such as document files, text files, Excel spreadsheets, Access databases and can put them into one master database. Something that can recognize addresses, city, states, zips, Names, phone numbers and place them in the proper fields on a master data form. I have many thousands of entries in several files that this needs to be done to. However all I've found has been "list appending services" that want anywhere from $.05 to $.80 per record to do. Plus they all seem to want $2500.00 up front to start. I have no guarantee that the work will be acceptable even if they are honest, but then they also have all my information which I deem too valuable to let someone have access to. Thanks! Jim

Answers

  1. jason146558

    On 2006-08-10 10:02:42


    You should be able to inter grate all your information using Windows XP Pro and Microsoft Office Suite 2000 or up

  2. Bhahagyam

    On 2006-08-10 10:09:09


    it is not podssible with a programme .you must use a LAN ,ATHE so called local area net work (LAN) which should be connected and the server pc will give you all the data base data to you in a Ring configuration .

  3. tazintampa

    On 2006-08-10 10:11:51


    This is a hard question to answer due to allot of unknowns. Is the data in the TXT or excel files formatted or in the same format as the master db? How many different files are you dealing with? Is one record per file or is their many records per document? What I can answer you is that with VB.net you or someone with some experience can write a simple code to collect the data and process it to the master data base. The biggest trouble is if all the documents are in different formats. Now that will make it hard program but not imposable. Off the shelf software will only work if you pre tweak the document to fit a specific format.

  4. rob

    On 2006-08-10 10:15:30


    Yes. PHP and MySQL using delimited files. Each database table has a column. For instance, say you have a table called phone_book. Your columns would be lastname, firstname, address, city, state, zip, etc. Delimited files are files that use a seperator, such as a comma, to represent a column in a database. So if you had this as your text file, Blow, Joe, 1234 Some Street, Anywhere, State, 11111, then that information would be put in the database in the appropriate columns. These files are usually in a .csv format. PHP and MySQL are great at this.

  5. Din's Desendit

    On 2006-08-10 10:01:36


    idk