It is possible to import the contents from an external file (CSV, Excel or Access) into the currently connected database.
However, the tables on both sides of the connection must have matching columns in terms of field type, otherwise the process could fail and return an error message.
You can refer to the following technote, which explains how to do it.