View Single Post

   
  #2 (permalink)  
Old 03-01-2008, 11:35 AM
Ed Murphy
 
Posts: n/a
Default Re: Transfer data from an excel sheet to table in sql data base

tamatem wrote:

> I have an excel sheet that contain colummns as in a table in a sql data
> base i want to transfer this data from the sheet to the table from
> business logic code layer not from the enterprise manager by wizard
> what can i do?? ...please urgent


Build a DTS job using the wizard, then save it for future
use. Depending on your situation, you may need to give it
a schedule, and/or use your business-logic layer to copy
an arbitrary filename to a fixed filename.
Reply With Quote