Import Excel to Access & Remove Header/Footer Rows

In this Microsoft Access tutorial, I will show you how to automate the process of importing Excel data into Access while removing unwanted header and footer rows. We'll tackle a common issue of having extra rows at the top and unnecessary summary rows at the bottom to streamline your data import process.

Brent from Midwest City, Oklahoma (a Gold Member) asks: I receive a daily quote report with multiple rows above the header and a totals row at the bottom that I don't need. Currently, I manually clean up the sheet before importing it into Access, but I'd like to automate this process. I've watched the import tutorials, but I'm not sure how to handle the unnecessary rows in an automated setup. Any guidance would be appreciated.

Members

There is no extended cut, but here is the database download:

•  Database Download - Gold Members

Silver Members and up get access to view Extended Cut videos, when available. Gold Members can download the files from class plus get access to the Code Vault. If you're not a member, Join Today!

Prerequisites

• Import Specific Sheet
• Intro to VBA
• Recordsets

Links

• Error Handling
• Variables

Recommended Courses

• Access Developer Courses
• Access Developer 16

Up Next

• Excel Import Cleanup, Part 2

Learn More FREE Access Beginner Level 1 FREE Access Quick Start in 30 Minutes Access Level 2 for just $1 Free Templates TechHelp Free Templates Blank Template Contact Management Order Entry & Invoicing More Access Templates

Resources Mailing List - Get emails when new videos released Consulting - Need help with your database Tip Jar - Your tips are graciously accepted Questions? Please feel free to post your questions or comments below or post them in the Forums.

Keywords

TechHelp Access, Excel to Access automation, Automate Excel import, remove header footer rows, Access database import, VBA recordset tutorial, Excel data cleaning VBA, delete top rows Excel VBA, Access VBA data import, clean spreadsheet for database, Brent's import challenge