Excel to SQL help

• • Reply

  12 years ago

  by orion3999

  Jay Lott

  , United States

  Joined 13 years ago

   Hello i am trying to write a query in SQL that will take specific fields from an excel spreadsheet and insert them into a sql database, based on two criteria being equal. i am not sure if i can even do this, and im not sure where (or how ) i would tell it to look for the excel table. i would code by hand, but then i would have to touch 70k of tables.

  here is how  i think it should look, but i know i am missing pieces of it.
   

  Update master m
  

  Set m.prodcl = prodcl.xls

  Where m.partno = partno.xls

  And m.revno= revno.xls

   I am a little lost to say the least
   

   

  Report abuse
• • Reply

  12 years ago

  by TimL

  Tim Leung

  Berkshire, United Kingdom

  Joined 13 years ago

  How about adding the excel spreadsheet as a linked server which would then allow you to query it using TSQL? 

  http://msdn.microsoft.com/en-us/library/ms190479.aspx

  Tim 

  Report abuse