excel sheet to sql RSS

• • Reply
  

  Samirko

  Member

  145 Points

  151 Posts

  excel sheet to sql

  Nov 12, 2010 03:47 PM|LINK

  
  

  I have an excel invoice in matrix form. i need to upload this excel sheet via my asp.net page

  I use to upload excel where the header column is same as columns in sql table

  but this excel is in matrix forms..  i need help plz
  

  Invoice Details
  Invoice number	0920961240	Invoicing address	Est.
  			Ab
  Invoice date	25.10.2010		Honk Kong
  Billing due date	24.11.2010
  Nk contact person	Invoicing Department
  VAT number	FI0980389
  Customer VAT number
  Nokia internal sales group	Nk Corporation
  Weight (Net/Gross) (KG)	4124/41240
  Volume (CDM)	147
  Terms of payment	Up to 24.11.2010 without deduction
  Customer order number	Elm/P10/N2002wk41	Delivery address	Eling tris Warehouse
  Nki SO ID	7231462		Shed No.3
  Date of order	16.9.2010		(Opp. Honda Service Center,
  Delivery note number	8002037483		2nd Green Color Warehouse)
  Delivery date	1.11.2010		215-9 A Um Rm St.
  Carrier	DHL LOGISTICS (CHINA) CO. LTD.		Japan
  Terms of delivery	CIP SHARJAH, INCOTERMS 2000		USA
  Item Code	Description	Quantity	Unit Price	Subtotal
  002S575	5250 RM-684 UE RED	100	123.00	12300.00
  			TOTAL AMOUNT (USD)	12300.00
  	Total Payable (USD)	12300.00

  s
  • Moved by MetalAsp.Net on Nov 12, 2010 03:57 PM
  • Marked as answer by Samirko on Nov 03, 2012 12:17 PM
• • Reply
  

  Samirko

  Member

  145 Points

  151 Posts

  Re: excel sheet to sql

  Nov 03, 2012 12:17 PM|LINK

  task was canceled

  s