SEO

#1 (**permalink**) 03-01-2008, 11:33 AM

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

#2 (**permalink**) 03-01-2008, 11:35 AM

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.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

SEO

Transfer data from an excel sheet to table in sql data base