Very Computer

1. Importing text files into SQL Server 2000 Database using DTS Import/Export Wizard

   I'm having a problem with exporting data from text files(received
by e-mail) into SQL Server 2000 Database. These files
were created by dumping the data from SQL Server 7
tables. Each row of
these files has a fixed length and  no special delimeters
between the fields - only spaces.The Wizard detected the import file as a
file with delimited fields(Screen "Select file format"). The next screen of
the Wizard detected the column
delimeter as "other", but I couldn't detect the character. As
soon as put in the delimeter field spaces, it gave me the wrong
number of colums in the result SQL Server Table( = junk).
    If I defined the file as a file with fixed length, the next screen
of  the Wizard I got the fields with
offset(they were not left justified). When I copied this file into
the database, I got the table with the wrong number of fields
and rong data in them.
Can anybody tell me, what is the problem and is it really
possible to import the data this way ?

Any suggestions are appreciated.

Sergei Cher

2. How to write code in control record[vb4]

3. Access 2000 to SQL Server 2000 using Import/Export Wizard or DTS

4. VFP: Development vs. compiled .EXE behaving differently -- lots of disk access, etc...

5. GB when trying to import .MDB file after installing Office 2000

6. update statement in a trigger

7. Installing Access 2000 With MS Office 2000 (Standard Version) Already Installed

8. Connecting MS Project to Oracle database

9. Jet doesn't work any more after installing Office 2000

10. Wheel mouse stopped working after SQL Server 2000 installed

11. SQLBindParameter for SQL_C_TIMESTAMP doesn't work in Windows 2000/Office 2000

12. Function not working with Windows 2000 or Office 2000