Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
pelegk2
Aged Yak Warrior
723 Posts |
 Posted - 2005-12-27 : 05:11:24
|
| i have a text file i want to import to a dbwhere i have problems with the columns that have 1)default value - like getdate() - whci h iwant it to be activated when i enter an empty field2)when i try to insert a time to a datetime col i recivev error(i tried to insert 25/12/2005 and 12/25/2005 and nothing helped!)any idea?thnaks in advancepelegIsrael -the best place to live in aftr heaven 9but no one wan't to go there so fast -:) |
|
|
shallu1_gupta
Constraint Violating Yak Guru
394 Posts |
Posted - 2005-12-27 : 05:55:22
|
| what is the structure of ur table and text file? and how r u importing it?and the error you are getting. |
 |
|
|
|
|
|
import text files with empty field and date