Post reply

excel order form to sql

  • September 30, 2009 at 12:42 pm

    #385475

    Hello

    My company is using excel order forms (received by fax, email,.. )

    They are really inefficient and right now our customer service has to retype them manually and they don't want to have a online system...

    So I am trying to automate the import of those excel spreadsheets to sqlserver, then send it to Db/2

    As you can see on the spreadsheet attached, I was thinking to create summary page for any values entered in the "Data Entry" Worksheet, so it will be easier to export them to sql later on.

    something like

    item / size / qty / price / discount

    I can create those manually, but those order forms are changing many times.

    So if anybody has any input how to automate this process or if there is a better way to achieve it, I will really appreciate it.

    Thank you very much for your time

    yohan

  • September 30, 2009 at 2:23 pm

    #1060182

    IF these forms all arrive via hard copy, snail mail, fax etc. and you are looking to streamline the operations without having someone retype them into a system of some sort, I might consider some sort of scanning solution...

    There are products out there that will scan a document and as long as the same feilds are in the same places on the document, it will grab those values, OCR and format them and then save them in a database. Usually, in systems like this there is some sort of manual review to confirm data accuracy. Kofax is the product we use for this type of thing, but it's not cheap. Perhaps there are other alternatives out there, but that's the one I'm familiar with.

    -Luke.

    To help us help you read this[/url]For better help with performance problems please read this[/url]

  • September 30, 2009 at 2:45 pm

    #1060193

    I agree with you, it will be easier, or even if do have an online form.

    But the company want to use what they have right now and making the import automatic

    Secondly, those forms are changing a lot which makes the OCR not easy to achieve

    Right now, most of the orders are coming from email.

    So I am trying to figure out the best way to have some orders flowing to our system.

    I was thinking to do a copy and paste special from the "data entry" to the "summary page"

    export the summary page to sql

    and query the values directly in sql, but it's a pretty heavy process

    so I am a little stucked for the last couple hours..

Viewing 3 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply