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)
 text import

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2001-10-10 : 09:25:39
Joerg writes "Hi all,

I have the following problem:
I use a textfile which I want to import into SQL Server 2000. The content looks like this:

**************************************************************************
..AN
090121037
..YR
2001-09-21
..SE
014
..RU
Industrie

The first line is the record delimiter, after each line a new record begins. The letters beginning with .. are the column names followed by the value. Not each column name appears in each record. And there are no specific characters for delimiting cloumns.

Is there a way to import this textfile?

Thanks

Joerg"
   

- Advertisement -