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.

 All Forums
 SQL Server 2000 Forums
 Import/Export (DTS) and Replication (2000)
 How can import text file into SQL Server

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2005-02-01 : 08:12:12
Mani writes "i have one text file. it contains like i want change in table format.

How it is possible

#Software: ActivMail -
#Version:
#Fields: DateTime,Mode,Status,MailServer,MessageID,To,QueueTime,[ErrorType],[LastCommand],[ErrorMsg],[QueryRowNumber]
"2004/01/04 19:00:09","Query","Error","postoffice.citysoft.com","13067651.8d50c0543023@postoffice.citysoft.com","Max Dugan <mxdigan@yahoo.com>","2004/01/04 19:00:01","SMTP","TO","501 This system is not configured to relay mail from <Tester@citysoft.com> to <mxdigan@yahoo.com> for 66.192.195.52","9""
   

- Advertisement -