Results 1 to 4 of 4
  1. #1
    Join Date
    Aug 2005
    Posts
    55

    Unanswered: import into more than 1 table

    Hi everyone,

    im trying to import data using a query...how ever i can only insert data into one table, and i need to insert data into many...this is at the part where you map the fields...

    is there a way to do this? or something similar?

    Thanks, Justin

  2. #2
    Join Date
    May 2004
    Location
    Seattle
    Posts
    1,313
    you could export your data to a flat file using bcp, then import that file to as many destinations as you like, again using bcp.

  3. #3
    Join Date
    Aug 2005
    Posts
    55
    Quote Originally Posted by jezemine
    you could export your data to a flat file using bcp, then import that file to as many destinations as you like, again using bcp.
    hi, and thanks for your reply...

    but im not sure what bcp is?

    Thanks, Justin

  4. #4
    Join Date
    Jan 2004
    Location
    In a large office with bad lighting
    Posts
    1,040
    Open up Books Online (or press F1 from the Query Analyzer screen) ... click on the INDEX tab ... type bcp ... peruse the various topics ... click on bcp utility for the syntax ... give it a try.

    -- This is all just a Figment of my Imagination --

Posting Permissions

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