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!
-
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!
Recent content by 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- JackK
- Thread
- Replies: 1
- Forum: Microsoft SQL Server: Programming
-
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- JackK
- Thread
- Replies: 0
- Forum: Microsoft SQL Server: Programming
