Post reply

Comparing tables in Access and SQL

  • January 30, 2009 at 1:23 am

    #200739

    Hi,

    I am importing tables from access to sql server 2005 using SSIS package(right click on database -> Tasks -> Import data)

    Now I have to compare whether the data imported to SQL Server is correct or not.

    Can I know how to compare the data in Access and SQL Server?

    Thanks

    Thanks,
    Santhosh

    Human Knowledge Belongs To The World !!

  • January 30, 2009 at 1:50 am

    #935331

    Hi,

    I just linked the access table to SQL Server 2005

    exec sp_addlinkedserver @server='AccessDb',

    @srvproduct='Access',

    @provider='Microsoft.Jet.OLEDB.4.0',

    @datasrc='C:\TEMP\csd.mdb'

    exec sp_addlinkedsrvlogin @rmtsrvname='AccessDb',

    @useself='false',

    @rmtuser='Admin',

    @rmtpassword=''

    I can see the tables and views in the access using

    sp_tables_ex 'AccessDb'

    and see the contents of a particular table using

    select * from openquery(AccessDb,'select * from table_name')

    and I can copy the contents of the table using

    select * into dbo.csd from openquery(AccessDb,'select * from table_name')

    Is this method and importing from SSIS package are one and the same?

    Thanks

    Thanks,
    Santhosh

    Human Knowledge Belongs To The World !!

Viewing 2 posts - 1 through 1 (of 1 total)

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