hi people, i am trying to export access data in form of excel tables and put on a ftp server. i have researched online and have found quite a number of resources online. however i couldnt get some of the vbas to work
i am quite confused here as i have read conflicting messages - the ms source (for office suggests following to export to ftp:
i've tried below methods but have receive error message (the file could not be found or you do not have write/read access to the file). When i looked it up online, a source says "
Microsoft has confirmed that this is a bug in the Microsoft products that are listed in the "Applies to" section."
Can anyone advise if export to FTP can be done in ACCESS 2007 using below methods? wondering if anyone has done it before.
---------------------------------------------------------
1) Use a Visual Basic for Applications procedure to export the object.
Sub ExportToFTP()
DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel97, _
"Shippers", "ftp://servername/shippers.xls"
DoCmd.TransferText acExportFixed, "Orders Export Specification", _
"Orders", "ftp://servername/orders.txt"
End Sub
2) Macro
Use a macro to export the objects. This sample macro exports the Shippers table as a Microsoft Excel spreadsheet and the Orders table as a text file from the sample database Northwind.mdb. Make sure that the FTP folder that you are exporting to has write permissions enabled or the export will fail.
Macro Name Action ------------------------- Macro1 TransferSpreadsheet TransferText Macro1 Actions ----------------------------------------------------- TransferSpreadsheet Transfer Type: Export Spreadsheet Type: Microsoft Excel 97 Table Name: Shippers File Name: ftp://ServerName/Shippers.xls Has Field Names: Yes TransferText Transfer Type: Export Fixed Width Specification Name: Orders Export Specification Table Name: Orders File Name: ftp://ServerName/Orders.txt Has Field Names: Yes---------------------------------------------------------
i am quite confused here as i have read conflicting messages - the ms source (for office suggests following to export to ftp:
i've tried below methods but have receive error message (the file could not be found or you do not have write/read access to the file). When i looked it up online, a source says "
Microsoft has confirmed that this is a bug in the Microsoft products that are listed in the "Applies to" section."
Can anyone advise if export to FTP can be done in ACCESS 2007 using below methods? wondering if anyone has done it before.
---------------------------------------------------------
1) Use a Visual Basic for Applications procedure to export the object.
Sub ExportToFTP()
DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel97, _
"Shippers", "ftp://servername/shippers.xls"
DoCmd.TransferText acExportFixed, "Orders Export Specification", _
"Orders", "ftp://servername/orders.txt"
End Sub
2) Macro
Use a macro to export the objects. This sample macro exports the Shippers table as a Microsoft Excel spreadsheet and the Orders table as a text file from the sample database Northwind.mdb. Make sure that the FTP folder that you are exporting to has write permissions enabled or the export will fail.
Macro Name Action ------------------------- Macro1 TransferSpreadsheet TransferText Macro1 Actions ----------------------------------------------------- TransferSpreadsheet Transfer Type: Export Spreadsheet Type: Microsoft Excel 97 Table Name: Shippers File Name: ftp://ServerName/Shippers.xls Has Field Names: Yes TransferText Transfer Type: Export Fixed Width Specification Name: Orders Export Specification Table Name: Orders File Name: ftp://ServerName/Orders.txt Has Field Names: Yes---------------------------------------------------------
