Export To TXT File - Notepad Too Small - Any Alternatives? 1

[eb24]

I have to export some SQL Server data to a .TXT file and Notepad will not do due to its size limitation, i.e. I believe it is 20 MB for ANSI and 60 MB for UNICODE.

I wasn't aware Notepad had any size restrictions, but oh well. I wanted to know what others out there are using for .TXT export files?

Thanks in advance for any advice.

 

[mrdenny]

do you need to edit the data, or just view the data in the file?

Denny

--Anything is possible. All it takes is a little research. (Me)

 

[eb24]

mrdenny:

Actually, I don't need to do anything with the actual .txt file, but send it off somewhere else by first encrypting it and sending it via FTP.

Thus, I do not need to edit/view it, but view might come in handy. Also, edit might nice as well.

 

[mrdenny]

You can use the type or view commands from a command line to view a file of that size. I wouldn't recommend opening it in anything unless it was absolutely neccessory. Wordpad can open large files like that, which notepad can't open. Wordpad is under accessories in the start menu, or start run wordpad.exe.

If you don't need to edit or view the file, a text file has no size limits (other than the 2 TB file size limit in windows). I've had text files well over 100 MB and the system can handle them without problem.

Denny

--Anything is possible. All it takes is a little research. (Me)

 

[OOGhostOO]

If its any help, we use Textpad to view/edit large files that are too big for Notepad.