After assigning a LIBNAME with the ODBC engine to a MS Access database
file, a DATA Step can be used to write a SAS data set to a new table in
the MS Access database.

 libname mylib odbc dsn="MSAccess Database";

 data mylib.newtable;
   set work.test;
 run;

If the following message is returned:

  WARNING: During insert: [Microsoft][ODBC Microsoft Access
           Driver]Fractional truncation (null)

compare the offending variable format to the underlying data values.
If the two do not match, the warning is issued to let the user know
that some of the data values may be truncated.

For example, a variable is formatted as 8., but some of the underlying
data has decimal values:

 64.124374
 186.158218
  76.504425
  64.698112

The user will need to decide how to handle these values, either as
truncated to integers (as the format is) or apply a format that will
preseve the fractional values.

Operating System and Release Information