How do I append to an access database? Do I need all variables in my SAS data set or I can append to the Access table with just some of them?
I tried this, but SAS didn't like my syntax.
proc sql noprint;
connect to odbc (dsn="CBR Tracker");
execute(insert * from to_tracking into Tbl_entry1) by odbc;
disconnect from odbc;
quit;
Thanks!