Hi All,
I have used the A5_ADOImportTable() genie to produce the code to import excel spread sheet, this works fine on my development system but on my distribution version I am getting an error of
Script: import add_excel line 46
to many parameters
I would be grateful of any help you can give
Andy
I have used the A5_ADOImportTable() genie to produce the code to import excel spread sheet, this works fine on my development system but on my distribution version I am getting an error of
Script: import add_excel line 46
to many parameters
I would be grateful of any help you can give
Andy
Code:
'password abc123 'Date Created: 30-Aug-2006 08:57:06 AM 'Last Updated: 15-Feb-2007 11:16:45 AM 'Created By : Andy Meer 'Updated By : Andy 'Create an XDialog dialog box to prompt for parameters. DIM SHARED exceladd as c DIM SHARED varC_result as C ok_button_label = "&OK" cancel_button_label = "&Cancel" varC_result = ui_dlg_box("Import Customer Address File",<<%dlg% {region} Please Select Your Customer Excel File Here:| [%p=ui_get_file("Please Select File","Microsoft Excel (*.xls)",exceladd,"");I=$a5_smart_file%.80exceladd]; {endregion}; {line=1,0}; {region} <*15=ok_button_label!OK> <15=cancel_button_label!CANCEL> {endregion}; %dlg%) 'Create an XDialog dialog box to prompt for parameters. DIM SHARED Sheet as C DIM SHARED varC_result as C ok_button_label = "&OK" cancel_button_label = "&Cancel" varC_result = ui_dlg_box("Excel Sheet Name",<<%dlg% {region} Please Enter Your Excel Sheet name ie. sheet1:| [.40Sheet]; {endregion}; {line=1,0}; {region} <*15=ok_button_label!OK> <15=cancel_button_label!CANCEL> {endregion}; %dlg%) 'exceladd = "C:\Customer_address" newaddd = "Add_temp.dbf" 'sheet = "sun" pImportResult = A5_ADOImportTable("Provider=MSDASQL;Driver={Microsoft Excel Driver (*.xls)};DBQ="+exceladd+"", "Sheet1$",var->newadd", "ACCOUNT,name,ADDRESS_ONE,ADDRESS_TWO,TOWN,COUNTY,post","","", .t., .f., .t., .t., .f., "",.f. ) end
Comment