nikkypickles
Total Novice
- Local time
- Today, 01:46
- Joined
- Jul 13, 2006
- Messages
- 122
Hi guys
Im trying to export xml and html files to an FTP server direct from an access form. I have found I can achieve this by using the export function by right clicking on the report in question.
The problem is I have hundreds of these files I need to export daily and would like to be able to do this with code. Therefore i need the code to export the report as xml and html (just like the wizard) and contain the username and password so no user intervention is needed.
I have searched the forum and the help files and have found nothing the explains the FTP part. The closest i found is:
Application.ExportXML _
ObjectType:=acExportTable, _
DataSource:="Customers", _
DataTarget:="Customers.xml", _
SchemaTarget:="CustomersSchema.xml", _
SchemaFormat:=acSchemaXSD, _
OtherFlags:=1
However this does not cover the FTP part. And I also need to export the html file.
Any help is greatfully appreciated
Im trying to export xml and html files to an FTP server direct from an access form. I have found I can achieve this by using the export function by right clicking on the report in question.
The problem is I have hundreds of these files I need to export daily and would like to be able to do this with code. Therefore i need the code to export the report as xml and html (just like the wizard) and contain the username and password so no user intervention is needed.
I have searched the forum and the help files and have found nothing the explains the FTP part. The closest i found is:
Application.ExportXML _
ObjectType:=acExportTable, _
DataSource:="Customers", _
DataTarget:="Customers.xml", _
SchemaTarget:="CustomersSchema.xml", _
SchemaFormat:=acSchemaXSD, _
OtherFlags:=1
However this does not cover the FTP part. And I also need to export the html file.
Any help is greatfully appreciated
