When I export a database table to a text file a have a field that is
datatype nvarchar 4000.
The value in the fields are being truncated to 255 chars. How do I stop this
from happening?
thanks,
Vince
by Vincent Apes » Tue, 15 Feb 2000 04:00:00
thanks,
Vince
by Neil Pik » Tue, 15 Feb 2000 04:00:00
Neil Pike MVP/MCSE. Protech Computing LtdQuote:> When I export a database table to a text file a have a field that is
> datatype nvarchar 4000.
> The value in the fields are being truncated to 255 chars. How do I stop this
> from happening?
> thanks,
> Vince
by Vincent Apes » Tue, 15 Feb 2000 04:00:00
All Tasks -> Export Data
then I'm selecting The SQL Server as the source and a text file as the
destination.
Any ideas?
Vince
--
> > When I export a database table to a text file a have a field that is
> > datatype nvarchar 4000.
> > The value in the fields are being truncated to 255 chars. How do I stop
this
> > from happening?
> > thanks,
> > Vince
> Neil Pike MVP/MCSE. Protech Computing Ltd
> (Please reply only to newsgroups)
> SQL FAQ (412 entries) see
> http://forumsb.compuserve.com/vlforums/UK/default.asp?SRV=MSDevApps
> or www.ntfaq.com/sql.html (+ ntfaq download)
> or http://www.sql-server.co.uk
by Neil Pik » Wed, 16 Feb 2000 04:00:00
Neil Pike MVP/MCSE. Protech Computing Ltd
(Please reply only to newsgroups)
SQL FAQ (412 entries) see
http://forumsb.compuserve.com/vlforums/UK/default.asp?SRV=MSDevApps
or www.ntfaq.com/sql.html (+ ntfaq download)
or http://www.sql-server.co.uk
1. Problems with Export of table to Acess and Text file
Hello,
I have tried to export a table that contains fields of datatype decimal,
however, when I export the data to MS Access, the values to the right of
the decomal point are never present. The number is rounded to the
nearest whole number.
I tried creating the target table in MS Access, and even changed the
field type in this table to decimal, but that didn't do the trick. I
haven't tried select convert(varchar(10), column1) yet.
Also can anyone please tell me how to export data from a SQL Server
table to a text file? I tried doing this but each time I tried to create
the target table, using the DTS Designer, I received an MMC execption,
which shut down the DTS designer.
Any help would be greatly appreciated.
Thanks,
Sam
*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!
3. Script to export tables data into text file based on table name
4. Problems with Oracle 9i on a SUN E450 and Solaris 8?
5. export multiple tables to a single text file
6. Upper ASCII characters - Above 126 - Newbie
9. Bulk export of tables to text files
10. Export Table Data to Text Files
11. Exporting a table to multiple text files
12. export table to a text file w/ bcp
13. Need XP to export table to text file