I am sorry, I am posting this message again, since I did not get any
reply.
I want to export a table into a "fixed width" file using SQL 2005
import export wizard.
This is the version I have:
SQL Server 2005 - 9.00.2047.00
For some reason it joins all the rows together. For EX: if the table
is like this:
Create table Mytable (col1 varchar(50) null, col2 varchar(60) null,
col3 varchar (100) Null)
Insert into MyTable values ("abcdef", "12345", "8900")
Insert into MyTable values ("xxxxxxx", "11111111", "22222222")
Insert into MyTable values ("yyyyyyyyy", "5555555555555555",
"6666666666")
Insert into MyTable values ("abcdef", "12345", "8900")
Insert into MyTable values ("xxxxxxx", "11111111", "22222222")
Insert into MyTable values ("yyyyyyyyy", "5555555555555555",
"6666666666")
It is not exporting every row in a single line. Actually if I open it
in "Ultra Edit", it is all in one line.
I used to do this regularly with SQL 2000 import export wizard and it
exported every row in one line.
I looked at the setting:
The header row delimiter has {CR}{LF}
Code page has 1252 Ansi-Latin.
In the Advanced tab:
String:dt_str.
I tried changing the header row delimiter to just {CR} or just {LF}.
Also I tried changing the string to dt_text and nothing seems to help.
Please help.
Thank you 1 7708
I'm having the same problem now. Were you ever able to resolve this?
It's weird since SQL 2000 works fine. ge******@hotmail.com wrote:
I am sorry, I am posting this message again, since I did not get any
reply.
I want to export a table into a "fixed width" file using SQL 2005
import export wizard.
This is the version I have:
SQL Server 2005 - 9.00.2047.00
For some reason it joins all the rows together. For EX: if the table
is like this:
Create table Mytable (col1 varchar(50) null, col2 varchar(60) null,
col3 varchar (100) Null)
Insert into MyTable values ("abcdef", "12345", "8900")
Insert into MyTable values ("xxxxxxx", "11111111", "22222222")
Insert into MyTable values ("yyyyyyyyy", "5555555555555555",
"6666666666")
Insert into MyTable values ("abcdef", "12345", "8900")
Insert into MyTable values ("xxxxxxx", "11111111", "22222222")
Insert into MyTable values ("yyyyyyyyy", "5555555555555555",
"6666666666")
It is not exporting every row in a single line. Actually if I open it
in "Ultra Edit", it is all in one line.
I used to do this regularly with SQL 2000 import export wizard and it
exported every row in one line.
I looked at the setting:
The header row delimiter has {CR}{LF}
Code page has 1252 Ansi-Latin.
In the Advanced tab:
String:dt_str.
I tried changing the header row delimiter to just {CR} or just {LF}.
Also I tried changing the string to dt_text and nothing seems to help.
Please help.
Thank you
This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics
by: Joe Morrison |
last post by:
By my reading of the HTML standard:
http://www.w3.org/TR/REC-html40/struct/tables.html
the HTML shown below should display the text "Enter password" with the
input field immediately adjacent,...
|
by: Rob Freundlich |
last post by:
I have some servlet-generated tabular data that I need to present, so I'm
using an HTML Table. In some cases, it can be quite large. I'm flushing
the servlet output every N lines to push the data...
|
by: Steve Richter |
last post by:
here is the start of my .aspx page:
<body>
<form id="Form1" method="post" runat="server">
<TABLE id="Table2" runat="server" width="100%" border="0">
I understand the width=100% attribute to...
|
by: booksnore |
last post by:
I'm looking for a way to sort text files consisting of fixed file
format. The files are big, typically over 10 million records and they
consist of about 100 fields with the record being over 600...
|
by: James Frayne |
last post by:
Hi,
I am trying to integrate phpBB into my existing site design. I am doing
this simply by pasting fragments of my HTML into the phpBB templates.
This works fine in Firefox and Opera but the...
|
by: gelangov |
last post by:
I want to export a table into a "fixed width" file using SQL 2005
import export wizard.
This is the version I have:
SQL Server 2005 - 9.00.2047.00
For some reason it joins all the rows...
|
by: Vinny |
last post by:
i'm not sure if this is the right group for this message, if not, i
apologize.
i have an application i'm writing which needs to bulk-load several
million records into an sql server table.
i'm...
|
by: Tantale |
last post by:
I used this serviec to check my webpage
http://www.jmrw.com/Abroad/Barcelone/index.htm Made with Dreamweaver 8.
The result is 206 errors, most of them "end tag omitted, but OMITTAG NO was...
|
by: BostonNole |
last post by:
Using Visual Studio 2005, .NET 2.0 and VB.NET:
I am looking for the fastest possible way to import a very large fixed
width file (over 6 million records and over 1.2 GB file size) into a...
|
by: CloudSolutions |
last post by:
Introduction:
For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome former...
|
by: Charles Arthur |
last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
|
by: ryjfgjl |
last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
|
by: ryjfgjl |
last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
|
by: BarryA |
last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
|
by: nemocccc |
last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
|
by: Sonnysonu |
last post by:
This is the data of csv file
1 2 3
1 2 3
1 2 3
1 2 3
2 3
2 3
3
the lengths should be different i have to store the data by column-wise with in the specific length.
suppose the i have to...
|
by: Hystou |
last post by:
There are some requirements for setting up RAID:
1. The motherboard and BIOS support RAID configuration.
2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
| |