Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. Erik70NY

    T-SQL debugger now working, but won't step through

    If you are using SQL 2000 SP3, you must run EXECUTE sp_sdidebug 'LEGACY_ON' each time SQL server is started in order for debugger to work properly.
  2. Erik70NY

    Excel import via DTS

    Why not just save off the excel file as a tab delimited text file, and then import that?
  3. Erik70NY

    Retaining Original Sort Order

    Thanks for responses. Ultimately I managed to solve this problem by altering my export routine within my source database(multi-value pick flavor) to included a column with sequential numbering, and then just sorted on that within my target sql table.
  4. Erik70NY

    Retaining Original Sort Order

    I imported a text file into a table and discovered upon completion that the original order of the rows as they appear in the text file is not the same as they appear in the target table. Is there a way to maintain the original order of the rows as they appear in the source file? Thanks in...
  5. Erik70NY

    Import Overlay

    Is it possible to set up a text import into Access whereby any rows with a particular primary key within a table are updated with the new values, and if the row doesn't exist within the table, append the new one. Here is an example: Access Table Sample Before Import PrimKey Name Phone #...

Part and Inventory Search

Back
Top