Exporting data from excel...

Ok,
I understand how to import data from MS SQL to Excel whenMS SQL is on different machine in the network. I am curious how to export data to the MS SQL databases from Excel on my machine... help is appreciated
thanks!Originally posted by ab8140
Ok,

I understand how to import data from MS SQL to Excel whenMS SQL is on different machine in the network. I am curious how to export data to the MS SQL databases from Excel on my machine... help is appreciated

thanks!

There are many ways to do this. Is it a one shot deal or are you going to be doing this over and over again with the same data? One way is to create a simple DTS package to access the spreadsheet and import it in. Another way would be to save the file as a text file and bcp it in. Or, you could write a simple vba app in excel that opens up an odbc or ado connection into sql and pumps the data in. Yes, there are many many ways depending on your specific talents and needs.|||As referred DTS can be used to accomplish the task, make sure SQL Services account does have necessary privileges when scheduling or executing such DTS packages.sql