Results 1 to 2 of 2
  1. #1
    Join Date
    Sep 2003
    Posts
    2

    Question Unanswered: Can you Import Data from an ODBC source with a SP?

    Can you Import Data from an ODBC source with a SP?
    I can do it with a DTS but I was looking to import the data using a stored procedure.

  2. #2
    Join Date
    Feb 2002
    Location
    Houston, TX
    Posts
    809
    Check out Linked Servers or if this is more of an adhoc thing check out OPENDATASOURCE() in books online.
    Either of these would allow you to establish an OLEDB/ODBC connection. Post back if you have more spacific questions, but please include a little more detail with your questions.
    Paul Young
    (Knowledge is power! Get some!)

Posting Permissions

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