![]() ![]() Open strPath & "FTP_Run.bat" For Output As pFile Im following a simple path of creating script file and then running FTP. 'Use the Put command to upload, use the Get command to download. I need to automate uploading file to FTP server from within Excels macro. Open strPath & "FTP_cmd.txt" For Output As pFile 'Create text file containing FTP commands StrFileName = "Test.mdb" 'Name of file to upload 'the same location as the mdb file that contains this module. 'Default directory location of files to upload/download is 'Craetes FTP Batch File, FTP command file (txt) A user simply clicks a command button anytime they want to update the website. I created a function to export a query to an mdb file and then FTP it to the web server. The data in the online database search is updated though an internal custom Access application. In the searchable online directory, an asp file interfaces with an Access database. One site suggested adding a reference to 'Microsoft Internet Transfer Control' and then define an 'Inet' object to do the FTP. Uploading user FE/BE and other files to my website (many times the files are too larger for email).Ĭlick here – to view a web application which is updated by this FTP function. I have an Excel worksheet where the user enters certain data, which I want to store in a text file and upload to a server using FTP.Downloading data from a web applications (for example: new orders in a shopping cart).Updating the back-end data of a web application.Some scenarios where I have used FTP in my custom Access application include: A developer can easily create their own ftp script to perform a variety of tasks for transferring files to and from a web server. This sample code demonstrated how to upload a file to a web server using Window’s FTP command. My Access Tips for Custom Microsoft Access Application Development by Matthew V Carmichael
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |