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!

Null values in sql server

Status
Not open for further replies.
rac55

rac55

Programmer
Jul 1, 2003
62
AU
Hi

I am importing an excel spreadsheet into tables in a sql server database using dts. I have one row of information filled out in the excel spreadsheet, but when the dts runs, it imports the information plus 5 extra rows filled with nulls ino the table.

Does anyone know how to fix this?

Thanks
Rachel
 
Sort by date Sort by votes
Hi

I have managed to get this working

Thanks
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

tekpr00
  • Locked
  • Question
Help with concatenation of BIG integers
Replies
0
Views
160
tekpr00
tekpr00
petart
  • Locked
  • Question
Problem Date MS SQL Server
Replies
0
Views
162
petart
petart
botatun
  • Locked
  • Question
the linked server insert data to csv in wrong order
Replies
0
Views
151
botatun
botatun
ItHurtsWhenIThink
  • Locked
  • Question
Using Distinct and count in same query???
Replies
4
Views
196
gk53
gk53
smsmail
  • Locked
  • Question
How to import EXCEL data into existing table in SQL Server
Replies
5
Views
288
markjoseph1232
markjoseph1232

Part and Inventory Search

Sponsor

Back
Top