Hi,
Is it possible to export a table to ms access using the web front end? I can do it with XLS,CSV,PDF but i cannot find a way to export it in access.
This script works in the desktop app, but how can i convert it to work within a web app?
Can anyone please help.
Thanks,
Denis
Is it possible to export a table to ms access using the web front end? I can do it with XLS,CSV,PDF but i cannot find a way to export it in access.
This script works in the desktop app, but how can i convert it to work within a web app?
Code:
dim connectionString as c connectionString = "{A5API='Access',A5Syntax='Access',FileName='I:\My Documents\alpha5 web database\OIDB\temp_oidb.mdb',UserName='Admin'}" delete options dim options as p options.ConsolidateArguments= .t. options.ShowProgress= .t. options.AllowCancel= .t. options.TableNamePrefix = "" delete a_export dim a_export[0] as p a_export[].LocalTableName = "tbl_obj_int_link.dbf" a_export[..].TargetTableName = "tbl_obj_int_link" a_export[..].TargetTableOwner = "" a_export[..].ExportFields = "" a_export[..].Filter = "" a_export[..].Order = "" a_export[..].QueryFlags = "" a_export[..].Arguments = "" a_export[..].ExportType = "Create new table" a_export[..].CreateTableSQL = "" a_export[..].DropExistingTable = "No" a_export[..].AppendFieldMap = "" a_export[].LocalTableName = "tbl_objects.dbf" a_export[..].TargetTableName = "tbl_objects" a_export[..].TargetTableOwner = "" a_export[..].ExportFields = "" a_export[..].Filter = "" a_export[..].Order = "" a_export[..].QueryFlags = "" a_export[..].Arguments = "" a_export[..].ExportType = "Create new table" a_export[..].CreateTableSQL = "" a_export[..].DropExistingTable = "No" a_export[..].AppendFieldMap = "" dim flagSilent as l delete args dim args as sql::arguments flagSilent = .f. delete p dim p as p p = a5_AlphaDAO_Export(connectionString,a_export,options,flagSilent,args) 'p has an .hasError and .errorText property 'a_export[] has the following properties for each item: .countRecordsExported, .hasError, .errorText, .userCancelled
Thanks,
Denis