Posted by Ed Murphy on 11/15/06 16:49

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.

[Back to original message]