Post reply

?? on compare table to external excel ss

  • May 29, 2012 at 9:18 am

    #392372

    Hi,

    not sure where to start I want to load data from an Excel SS that contains City States and zip

    to an existing table

    Thanks

    Joe

  • May 29, 2012 at 9:33 am

    #1494248

    Just use the import data wizard. You can import directly into an existing table or to a temp table and then insert to the existing, whatever you prefer.

    Just right click on database in SSMC, select Tasks->Import Data from the context menus.

    The probability of survival is inversely proportional to the angle of arrival.

  • May 29, 2012 at 11:39 am

    #1494319

    Thanks for the info..

    Ok I created a table called User_Zips.

    The DB has a table called Zip

    I want to know which ones are on User_zips that are NOT on Zip?

    Thx

  • May 29, 2012 at 12:00 pm

    #1494324

    Fix table and column names as needed:

    SELECT uz.*

    FROM User_Zips uz

    LEFT JOIN Zip z ON uz.zip_code = z.zip_code

    WHERE z.zip_code IS NULL;

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

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

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