Post reply

Import flat file into existing table using wizard

  • July 2, 2008 at 8:06 am

    #194608

    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.

  • July 2, 2008 at 8:42 am

    #837287

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

    Greg

  • July 2, 2008 at 12:50 pm

    #837418

    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

  • July 3, 2008 at 12:54 pm

    #838088

    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

    Thanks -- Vijaya Kadiyala
    www.dotnetvj.com
    SQL Server Articles For Beginers


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

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