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?

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.

Good luck,
Cheers.

I would imagine that you will need to FTP the file upto the web share

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.

Thx

What have you tried?

Have you tried the filecopy method from access?

Yes,
I've tried the filecopy method in access and also just an xcopy with a batch file

How about mapping the drive first in the batch file with

NET USE Q: \\Server\share

then file copy to q

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.

Where is this server? Is it physically plugged into your network?

Good question.
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.

can you manually copy files into it?

YUP.

Can you make access create a file in that folder (as a test)

Nope.
error: "Bad file name or number"

On the first Line?

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