G Guest Sep 30, 2004 #1 Can I edit an excel file from an Access Module. I only need to update one cell from No to Yes. Thank you for your help, Diana
Can I edit an excel file from an Access Module. I only need to update one cell from No to Yes. Thank you for your help, Diana
J Jamie Collins Sep 30, 2004 #2 Sophia said: Can I edit an excel file from an Access Module. I only need to update one cell from No to Yes. Click to expand... To change e.g. cell B3: UPDATE [Excel 8.0;HDR=NO;Database=C:\MyWorkbook.xls;].[MyWorksheet$B3:B3] SET F1='Yes' ; Jamie. --
Sophia said: Can I edit an excel file from an Access Module. I only need to update one cell from No to Yes. Click to expand... To change e.g. cell B3: UPDATE [Excel 8.0;HDR=NO;Database=C:\MyWorkbook.xls;].[MyWorksheet$B3:B3] SET F1='Yes' ; Jamie. --
