Samples of how to transfer XML files to a remote server/PC?? 1

[steve728]

OK, I know how to export and import XML data using VBA. Will someone out there please give me some examples or a helpful web site to use as a reference on the subject of physically tranferring the data to a remote server/WinXP PC? Also how to get data from a a distant server / WinXP PC? This will help my career so much!

Thanks in advance.

Steve728

 

[BNPMike]

What's the difference between "export" and "physically tranferring the data to a remote server".

Is this to do with LANs versus the Internet?

 

[steve728]

I want to physically transfer an XML file that was recently
created with MS Access 2002 locally and SEND it to a remote
server someplace else in the world so it can then import the xml file (data) into it's appropriate data table.

Thanks for your reply.

Steve728

 

[BNPMike]

Sorry Steve, I'm missing something.

When you create a file, you specify where that resides and that could be anywhere in the world. If the target machine is addressable using the normal LAN-type nomenclature (like x:\taget\data\transfers) then either create it directly there with your VBA or look at the VBScripting library which gives you FileSystemObject for addressing file systems.

I guess in your case - and this is why I asked the question before - you have got to use the Internet. You can make a remote server directly addressable but usually people stop you for security reasons. The common way to 'send' files is FTP. Have you tried that?

 

[steve728]

Thank you so much for all this help! You really deserve a star and I will do so now. Yes transferring the file(s) to an FTP site would be fine and makes more sense. Are you saying that the export to XML file process can actually include the remate address to my ultimate destination? ftp://68.63.185.84/MyXMLFiles

I also need to learn how to use VBScript on a remote server to automatically export into an XML file to my local
Server or WinXP Pro. Where can I learn all this. A web site perhaps or textbook? Is the FileSystemObject an important part of all this?

Thanks again!!!!!

Steve728

 

[BNPMike]

To export directly, you probably need to use the standard LAN addressing (it's called Universal something ot other). I guess from what you are saying you need to use IP-type addressing. I'm not sure whether FileSystemObject does ftp. You'll get full details off the Microsoft site or from a VB Script book. To use this library in VBA you have to specifically select it.

To automate ftp, I would suggest you look at cURL

http://curl.haxx.se/

although I'm sure there is some Microsoft equivalent.

 

[MichaelRed]

" ... I know how to export and import XML data using VBA ... "

on the off chance you are still listening, I do not, but would like to ...




MichaelRed