Import flat file into existing table using wizard

  • How do you import data into an existing table using the import wizard? It doesn't seem to allow that function. I can import data into a new table, but not add data to an existing one.

    But I haven't played around with the Wizard that much yet.

    Thanks.

  • I haven't had any problem importing data to an existing table. Do you get any error messages?

    Greg

  • Where it displays the target table, you can either type in an existing table, or click the down-arrow next to that and it will let you select an existing table.

    Make sure you click the Mappings button if you do that, to make sure columns will end up in the right places.

    - Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
    Property of The Thread

    "Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon

  • Hi,

    Please let us if you are facing any problem. If youa re not clear on the process then Check out the below link

    http://support.microsoft.com/default.aspx/kb/321686

    Thanks -- VJ

    http://dotnetvj.blogspot.com

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply