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 Shaun E 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: *

  • Users: JackK
  • Order by date
  1. JackK

    DTS drops first row

    I am using DTS to import an XLS file into a SQL Server 7.0 table. On several imports of different files, all the rows are sucessfully imported EXCEPT the first row from the XLS file. Any insights as to what the problem is? Thanks, Jack
  2. JackK

    Batch inserts from a text file?

    Hi, I am a rookie with SQL Server so bear with me. I am trying to insert rows into a table using a formatted text file as input. I would prefer not to used the Import Wizard and just write the SQL. Can anybody tell me what syntax I should be using? Thanks in advance. Jack

Part and Inventory Search

Back
Top