File Format & Compatibility

How to Recreate an Excel Report Layout in Microsoft Access

Ayan Masood Sep 29, 2026 869 views

Question details

The user needs to replicate an Excel worksheet's print layout, including font scaling and page dimensions, within a Microsoft Access report.

How to Recreate an Excel Report Layout in Microsoft Access

Product: Microsoft Access, Microsoft Excel
Device & OS: not provided
Scenario: Importing formatted worksheet data from Excel into Access to generate a cleanly formatted, printable database report.
Observed behavior: Microsoft Access does not automatically import or inherit an Excel worksheet's print layout, page dimensions, or automatic font scaling settings.

Before you start

Ensure your Excel worksheet is organized cleanly as a flat data table with clear column headers and no merged cells, as this makes the initial import process into an Access database much smoother.

Solution 1Recommended

Import Excel Data and Create a New Access Report Manually

Since Access cannot directly import an Excel print layout, you must import the raw data first and then use the Access report design tools to manually recreate the formatting and scale.

Microsoft Access treats imported Excel files purely as data sources. It does not carry over print settings like 'Fit to One Page' or automatic font scaling. You will need to manually reconstruct the layout using the Access Report Design and Print Preview tools.

Import the Excel Data

Open Microsoft Access, go to the 'External Data' tab on the ribbon, and click 'New Data Source' > 'From File' > 'Excel'. Follow the wizard to import your worksheet into a new Access table.

Generate a Basic Report

Select the newly created table in the Navigation Pane on the left. Go to the 'Create' tab and click 'Report' or 'Report Wizard' to generate a basic report layout based on your data.

Adjust Page Settings

Switch to 'Print Preview' or 'Layout View'. Navigate to the 'Page Setup' tab to modify the page orientation (Landscape or Portrait) and adjust the margins to maximize the printable area.

Scale Fonts and Columns

Manually resize column widths by dragging their borders. Adjust the font sizes for headers and data rows to ensure all information fits neatly within the page boundaries.

Export for Final Printing

Once the layout is perfected, use the 'External Data' tab to export the finished Access report to PDF or back to an Excel file for seamless distribution and final printing.

Import Excel Data and Create a New Access Report Manually

Estimating Access Font Sizes from Excel: To estimate the required font size, disable 'Fit to One Page' in Excel to see how many pages wide the report is naturally. If a 12-point font spans 1.5 pages wide, divide 12 by 1.5. This gives you an estimated Access font size of 8 points to use as a starting point.

Free Microsoft Office alternative

Manage Your Spreadsheet Reports Easily with WPS Office

While Microsoft Access is great for relational databases, handling complex report formatting is often much easier within a dedicated spreadsheet application. WPS Office offers a free, lightweight, and highly compatible alternative to Microsoft Office, complete with intuitive print-scaling features that make generating professional spreadsheet reports effortless.

Fully compatible with Microsoft Excel formats (.xlsx, .xls, .csv).Advanced print layout tools, including one-click 'Fit to Page' and custom margin scaling.Completely free and lightweight, ensuring fast performance on any device.Familiar tabbed user interface means zero learning curve when migrating from MS Office.

microsoft office alternative - wps office

Frequently Asked Questions

Why doesn't Access keep my Excel font scaling and print layout?

Microsoft Access only imports raw data (like text and numbers) from Excel, completely ignoring formatting or print settings. Access utilizes a distinct reporting engine, which requires you to manually define margins, orientation, and font sizes.

Is there a way to automatically scale an Access report to fit on one page?

Unlike Excel's 'Fit to One Page' feature, Access does not have an automatic scaling option for its reports. You must manually decrease font sizes, reduce column widths, or change the page orientation in Print Preview to fit the content onto a single page.

Can I export my completed Access report back to Excel?

Yes. You can export an Access report by opening it in Print Preview, navigating to the Data group, and selecting the Excel icon. However, exporting a report to Excel might alter complex visual formatting, so exporting directly to PDF is generally recommended for preserving the exact layout.

Document & File Issues