Results 1 to 6 of 6

Thread: Join Excel with Table in SQLSERVER

Hybrid View

  1. Jul 5th, 2007, 10:54 AM #1
    Mark Gambo
    Mark Gambo is offline
    Giants World Champs!!!! Mark Gambo's Avatar
    Join Date
    Sep 2003
    Location
    Colorado
    Posts
    2,965

    Re: Join Excel with Table in SQLSERVER

    How about creating a temporary table and then import the data in to the table and then join as normal
    Regards,

    Mark

    Please remember to rate posts! Rate any post you find helpful. Use the link to the left - "Rate this Post". Please use [highlight='vb'] your code goes in here [/highlight] tags when posting code. When a question you asked has been resolved, please go to the top of the original post and click "Thread Tools" then select "Mark Thread Resolved."

    Reply With Quote Reply With Quote
  2. Jul 6th, 2007, 12:12 PM #2
    erickwidya
    erickwidya is offline

    Thread Starter
    Fanatic Member
    Join Date
    Sep 2004
    Location
    Jakarta, Indonesia
    Posts
    818

    Re: Join Excel with Table in SQLSERVER

    not quite understand

    it need to be execute against Network Server not local Server..

    not sure how to work with this one

    1st NF - a table should not contain repeating groups.
    2nd NF - any fields that do not depend fully on the primary key should be moved to another table.
    3rd NF - there should be no dependency between non key fields in same table.
    - E. Petroutsos -

    eRiCk

    A collection of "Laku-abis" Ebook, Permanent Residence

    Access Reserved Words, a Classic Form Bug, Access Limitation, Know run Process and the Lock they hold in, Logging User Activity in MSSQL,
    Kill Database Processes
    Reply With Quote Reply With Quote
  3. Jul 6th, 2007, 05:06 PM #3
    Mark Gambo
    Mark Gambo is offline
    Giants World Champs!!!! Mark Gambo's Avatar
    Join Date
    Sep 2003
    Location
    Colorado
    Posts
    2,965

    Re: Join Excel with Table in SQLSERVER

    Quote Originally Posted by erickwidya
    not quite understand

    it need to be execute against Network Server not local Server..

    not sure how to work with this one
    What I am trying to say is first create a temporary table in your SQL Server Database and then import the excel spreadsheet, via DTS, into that temporary table. Now join the temporary table with the other tables as you would normally do. I think you would be better off creating a Stored Procedure (SPROC) to accomplish this.
    Regards,

    Mark

    Please remember to rate posts! Rate any post you find helpful. Use the link to the left - "Rate this Post". Please use [highlight='vb'] your code goes in here [/highlight] tags when posting code. When a question you asked has been resolved, please go to the top of the original post and click "Thread Tools" then select "Mark Thread Resolved."

    Reply With Quote Reply With Quote
  4. Jul 8th, 2007, 07:29 PM #4
    erickwidya
    erickwidya is offline

    Thread Starter
    Fanatic Member
    Join Date
    Sep 2004
    Location
    Jakarta, Indonesia
    Posts
    818

    Re: Join Excel with Table in SQLSERVER

    thanks Mark Gambo
    DTS need to be run manually right? or do that via Job Schedule ?
    it can be done but it can't be used since this is end user that involved..and this one needs to do it automatically..

    i have this i create linked server then do that via OPENQUERY..

    i'm not sure about the performance though

    thanks,
    erick

    1st NF - a table should not contain repeating groups.
    2nd NF - any fields that do not depend fully on the primary key should be moved to another table.
    3rd NF - there should be no dependency between non key fields in same table.
    - E. Petroutsos -

    eRiCk

    A collection of "Laku-abis" Ebook, Permanent Residence

    Access Reserved Words, a Classic Form Bug, Access Limitation, Know run Process and the Lock they hold in, Logging User Activity in MSSQL,
    Kill Database Processes
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules


Click Here to Expand Forum to Full Width