excel order form to sql

• yohan beghein

  SSC Enthusiast

  Points: 117

  More actions

  September 30, 2009 at 12:50 pm

  #211603

  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

• LutzM

  SSC Guru

  Points: 107049

  More actions

  September 30, 2009 at 1:18 pm

  #1060146

  duplicate post.

  please continue discussion here .

  ---

  
  Lutz
  A pessimist is an optimist with experience.

  How to get fast answers to your question[/url]
  How to post performance related questions[/url]
  Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]