Limit your file import to no more than 255 columns, which corresponds to the limit of 255 table fields imposed by Access. You can't skip columns when you import into a database that already exists.

After you add an attachment field to an Access table, you can import PDF files into any of the table's rows. You can then view them from within Access because they become part of your database.

If you import an excel file into Access it doesn't let you define the field type, but when you import a .csv you can define the field type to 'memo' or 'text' etc.