Error: The export style must be 'Single Row' for the currently selected - when exporting into Microsoft Access 2007

I'm in Export, and trying to Export into Microsoft Access 2007 Database (ACCDB) using the one-to-many function, and I'm receiving the following error: The export style must be 'Single Row' for the currently selected

There are two options to resolve this issue:

  • Select Tools > Export Options and change the Export Format to Microsoft Access 2000 Database. 

OR 

  • Select Tools > Export Options and change the Export Format to Comma Separated Values or Excel 97-2000.

Then, import the file into an Access database via the External Data tab in Access.

 

Environment

 7.93.5782.7 ; 7.92.5058.0

Was this article helpful?