Is there a method to export and import xml from/to SQL Server 7 without
using ADO ??
Robert Vabo
by Robert Vab » Wed, 02 Feb 2000 04:00:00
Robert Vabo
by Frank Mante » Wed, 02 Feb 2000 04:00:00
http://msdn.microsoft.com/workshop/xml/articles/xmlsql/sqlxml_prev.asp
This allows you to transfer data both ways. Check it out and feel free to
come back with questions etc...
Regards
Frank Mantek
Microsoft
> Robert Vabo
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. Connecting to SQL server remotely with Access.
3. how can I import and export DTS package and SQL Server Agent between SQL Server Groups
4. PARADOX FOR DOS V4.5 AND DOS/WIN 3.1
5. Import / Export Question from MS SQL Server 2000 to MySQL Server
6. Are versions 8.1.5 and 8.1.6 buggy?
8. SQL 7 Query Analyzer keeps crashing on Win98
9. export/import to/from XML file
12. import/export data in xml formay
13. Import/Export XML formatted files