Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
balamurugan
Starting Member
15 Posts |
 Posted - 2004-03-11 : 12:11:40
|
| I am trying to load an excel file into SQL SERVER 2000 and also to retrieve and store it in a directory. I don't see "TEXTCOPY" utility is installed in my server. How to download the utility?.ThanksBala. |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-03-11 : 12:39:59
|
| You must not have installed the samples. You will need to add them through the installation.Tara |
 |
|
|
balamurugan
Starting Member
15 Posts |
Posted - 2004-03-11 : 12:43:39
|
| Thanks for your reply.Are you refering "TEXTCOPY" C++ program?. Do I need to compile this program? |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-03-11 : 13:11:18
|
| Yes I am referring to it. Look up TextCopy in SQL Server Books Online. You'll see this default path:C:\Program Files\Microsoft SQL Server\80\Tools\Devtools\Samples\DBLib\TextCopyYou'll notice that Samples is in the path. So you would have needed to install the samples when you installed SQL Server to get this.Tara |
|
|
|
balamurugan
Starting Member
15 Posts |
Posted - 2004-03-12 : 11:04:58
|
| Thanks for your help. It works fine. I am having another issue...I would like to save the file in a another server. So Can I give UNC name to this utility?.I am getting an erro when I try this..."ERROR: Problem with file '\\servername\foldername\filename'." |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-03-12 : 12:17:15
|
| Since it doesn't work, I would suspect that you can't do that. I have not heard of anyone using this utility in the first place though. It might be hard to find someone to help you out on this.Tara |
|
|
|
balamurugan
Starting Member
15 Posts |
Posted - 2004-03-12 : 14:01:06
|
| Based on what I read in the forum, I understand that it is not good option to store image/files in the SQL server instead store the file path. What are the disadvantage of storing it in the sql server?. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-03-12 : 15:03:27
|
| It has been discussed at length here. Please do a search in the forums for the threads relating to this.Tara |
|
|
|
stumap
Starting Member
1 Post |
Posted - 2004-03-30 : 19:01:02
|
I have successfully inserted images using a UNC path '\\server\share\folder\image.jpg'.You might have to test the UNC path from your server, since that is where the code is executedquote:
Originally posted by balamurugan
Thanks for your help. It works fine. I am having another issue...I would like to save the file in a another server. So Can I give UNC name to this utility?.I am getting an erro when I try this..."ERROR: Problem with file '\\servername\foldername\filename'."
|
|
|
|
|
|
|
TEXTCOPY UTILITY