From the course: Building Solutions Using Excel and Access 2019 Together

Unlock the full course today

Join today to access over 22,600 courses taught by industry experts or purchase this course individually.

Create Access tables from Excel data

Create Access tables from Excel data

From the course: Building Solutions Using Excel and Access 2019 Together

Start my 1-month free trial

Create Access tables from Excel data

“

- [Instructor] Most people are familiar with just setting up a spreadsheet. Not every user has adopted naming cells but naming cells gives us the ability to import our linked database on the name. Named ranges are cell references that have a name in Excel. I would encourage you to check out the Excel 2016 Introduction to Formula and Functions course where they talk about named ranges. Let's go take a look at how to import named ranges into our database. I'll go to the External Data tab, I'll go to New Data Source, I'll choose From File, I'll go to my Excel file, I'll browse to my exercise files, I'll choose my original file, and then importing, I'm just bringing a copy in. At the top, you notice it says Show Worksheets or Show Named Ranges, I'll choose Show Named Ranges. And then I see zip codes. This file has a range called Zip Codes already included. Some systems that we export exports out and names our cells for us automatically. I'll go ahead and choose Next. The first row does…

Contents