excel 2003 and sql server edtion

• jon pill

  SSCommitted

  Points: 1659

  More actions

  July 3, 2007 at 8:44 am

  #177324

  I havedownload the MS free sql edtion but dont have any coding experience using sql, just  access a few years ago using sql.

  I have built an excel spreadsheet on vb code, and would like to push the totals into a sql server table  and the pull them across a netowrk into another pc.

  The totals are calculated every 1.5 seconds in the excel vb code.

  Can anyone supply me with the code to push excel to sql, then sql to excel.

  I guess the sql code will need to push the data to excel on a time bases maybe 1 sec.

  Many thank for reading this

   

   

   

   

   

   

   

• bledu

  SSChampion

  Points: 12335

  More actions

  July 5, 2007 at 5:11 am

  #717332

  to read your excel file you can use openrowset

  SELECT

  * FROM OPENROWSET('Microsoft.Jet.OLEDB.4.0',

  'Excel 8.0;DATABASE=c:\MyCalculation.xls', 'Select * from [Book1$]')

  ---

  Everything you can imagine is real.
  

• Sugesh Kumar

  One Orange Chip

  Points: 27311

  More actions

  July 5, 2007 at 5:36 am

  #717340

  Since you know VB you can also give a try on using the SSIS.

  Cheers,
  Sugeshkumar Rajendran
  SQL Server MVP
  http://sugeshkr.blogspot.com