Mar 21 2007, 03:27 PM
I currently export data as Excel files to a shared directory.
Now I will need to export them to my SharePoint site.
The document location is a web folder and not a network share so my copy command or other copy batch files apparently do not work.
Any idea how to do this?
Mar 21 2007, 03:44 PM
I am guessing but I think you will need permission to write to that directory. It does not need to be shared but you will require write permissions for the logged in user.
Try and copy any file from C:\ and then navigate to the web site and see if you can paste it there. If not then see error message.
Mar 21 2007, 03:56 PM
I would imagine that you will need to FTP the file upto the web share
Mar 21 2007, 04:04 PM
I am the site owner so I have full read/write ability.
I can see the folder in the File Explorer window under my network connections and can drag/drop files to/from it.
I just can't do it via a batch file for some reason, which is what I want to do since I need to auto copy about 80 files each day.
Re: FTP, I am not really familiar with it, so I'd need some example of how to automate an upload through it if possible.
Mar 21 2007, 04:19 PM
What have you tried?
Have you tried the filecopy method from access?
Mar 21 2007, 04:42 PM
I've tried the filecopy method in access and also just an xcopy with a batch file
Mar 21 2007, 07:32 PM
How about mapping the drive first in the batch file with
NET USE Q: \\Server\share
then file copy to q
Mar 22 2007, 07:33 AM
I'm missing part of the puzzle here as it won't let me map that has to do with the fact this is considered a "web folder".
Doing the above or trying to map from File Explorer I just get an error of: "Network name cannot be found".
I can do the "create a shortcut to a web folder" sucessfully but I already have that and cannot batch copy to it either.
Mar 22 2007, 08:02 AM
Where is this server? Is it physically plugged into your network?
Mar 22 2007, 08:14 AM
I believe it's off site at another location.
All I know about it is that ist shows up in my file explorer under "My network places" section.
When browsing the files they show an internet address location, not a drive lettered path for their location properties.
Mar 22 2007, 09:10 AM
can you manually copy files into it?
Mar 22 2007, 09:12 AM
Mar 23 2007, 04:45 AM
Can you make access create a file in that folder (as a test)
Open "\\ServerName\ShareName\Myfile.txt" for output as #1
print #1, "hello"
Mar 23 2007, 07:17 AM
error: "Bad file name or number"
Mar 25 2007, 04:57 PM
On the first Line?
Apr 2 2007, 12:34 PM
FYI I've found a solution in case anyone ese is looking at this thread.
Apparently you just cannot map to a web folder from Windows 2000. XP does have this capability on it's own.
For Win2000 users here's an app that I found on-line elsewhere
You can purchase an app ($40.00) that works well for this here:http://www.southrivertech.com/download/index.html
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here