Results 1 to 3 of 3
  1. #1
    Join Date
    May 2003
    Posts
    25

    Unanswered: 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!

  2. #2
    Join Date
    Dec 2002
    Posts
    63

    Re: Exporting data from excel...

    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.

  3. #3
    Join Date
    Aug 2002
    Location
    Scotland
    Posts
    1,578
    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.
    --Satya SKJ
    Microsoft SQL Server MVP
    [IMG]http://sqlserver-qa.net/google_bart.gif[/IMG]

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •