The following code fails when writing out records to a Microsoft Access database. You would need to create a table called ‘result’ with a numeric field called ‘Day’ to run the below (as well as change the name/path of the database)
param odbc_driver symbolic := 'DRIVER={Microsoft Access Driver (*.mdb, *.accdb)};dbq=.\data.accdb';
table PUT_RESULTS_1 {d in 1..10} OUT 'ODBC'
odbc_driver
'DELETE FROM result; ' # NOTE THE SPACE AFTER THE ;
'result' :
d ~ Day
;
The issue is the space after the ‘;’ in the DELETE statement. If you took it out, it works. That is, the following works:
param odbc_driver symbolic := 'DRIVER={Microsoft Access Driver (*.mdb, *.accdb)};dbq=.\data.accdb';
table PUT_RESULTS_1 {d in 1..10} OUT 'ODBC'
odbc_driver
'DELETE FROM result;' # NOTE THE LACK OF A SPACE
# BETWEEN THE ; and the end-quote
'result' :
d ~ Day
;
Marc Meketon
Oliver Wyman Digital
1 University Square, Suite 100 | Princeton, 08540
Direct: +1 (609) 520-2188
Mobile: +1 (732) 558-8931
address@hidden
www.oliverwyman.com
ASSISTANT
Jane Volz | address@hidden