In this tutorial I show you the best ways to export your Microsoft Excel 2016 spreadsheets to Microsoft Access. I show you the best way to fill out your Excel workbook for exporting to Access. This demo is done using Windows 10. Importing and Exporting is a key feature of the Microsoft Office 365 suite, and this tutorial is meant for beginners who would like to learn how to use the program more efficiently. I also discuss how to import and append an excel spreadsheet into a current Access table.
Here is a full list of tutorial videos available on my channel:
Windows 10:
Perform Basic Mouse Operations
Create Folders
Explore the Windows 10 Desktop, Taskbar, and Start Menu
Select Multiple Files and Folders
Download a File From a Website
Use File Explorer to Access OneDrive and Upload Student Data Files
Word 2016:
Create a New Document and Insert Text
Insert and Format Graphics
Insert and Modify Text Boxes
Create a Table
Format a Table
Present a Word Document Online
Create a Research Paper in MLA Format
Insert Footnotes in a Research Paper
Create Citations and a Bibliography
Save a Document
Correct Errors as You Type
How to Format a Document in APA Format
Convert Word Document to a PDF File
Microsoft Office Specialist Certification Exam Practice Study Guide
APA Format from Default Formatting
Table of Contents Tutorial
Format Paragraphs
Create a Custom Word Template
Excel 2016:
Create, Save, and Navigate an Excel Workbook
Enter Data in a Worksheet
How do you Export Access to Excel and Apply Conditional Formatting
Use Flash Fill, SUM, Average, Median, and MAX Functions and Formulas
Move Data and Rotate Text
Graph Data with a Pie Chart
Format a Pie Chart
MOS Prep – Basic Certification Exam Practice Study Guide
Change Fonts, Font Style, and Font Color
The NOW Function
Export Excel Spreadsheet to Access Table
The VLookup Function
The MIN or MINIMUM Function
Histogram Charts
Use the Sum Button to Sum a Range of Cells
Enter Formulas Using the Keyboard
Access 2016:
Identify Good Database Design
Create a Table and Define Fields in a Blank Desktop Database
The Primary Key
Import Excel Spreadsheet into Access
Create a Table in Design View
Modify the Structure of a Table
Create a Subform
MOS Prep – Basic Certification Exam Practice Study Guide
Add Existing Fields to a Form
PowerPoint 2016:
Create a New Presentation
Edit a Presentation in Normal View
Add Pictures to a Presentation
Format Numbered and Bulleted Lists
Customize Slide Backgrounds and Themes
Animate a Slide Show
Apply a Theme Used in Another Presentation
Search for and Download an Online Theme
Outlook 2016
Basic Tutorial
YouTube Analytics:
100 Subscribers
200 Subscribers
300 Subscribers
500 Subscribers
Computer Fundamentals:
Computer Case Types – Dell Inspiron AMD 3656
Printer Ports and Types
The Boot Up Process
How to Get Your Computer Questions Answered
Undo Your Mistakes on Windows 10 or Apple Mac
Routers vs. Modems
What is the Cloud? Storage as a Service
Types of Internet Services on Google Android or Apple iPhone
Browsing the Web
Why Use the Cloud?
Microsoft OneDrive – Creating Uploading Downloading and Syncing
Explain the Importance of File Management
Troubleshoot Common Computer Problems
Job Search Skills:
Values, Attitude, and Goals
Top 5 Job Search Websites
Prepare For Your Interview
Negotiating Your Salary
Video Requests:
Download GMetrix Test Preparation Software
Remember, the goal of my channel is for you to learn. You can request a video at any time in the comment section, and I will make the video for you. I will make tutorials and simulations and demos for whatever you’d like to learn in our class. So, I encourage you to make a request. I also YouTube Live Stream once a week to answer your questions!
Instructor A Morgan
access
Excel
to
2016
import
how
export
in
data
spreadsheet
importing
from
ms
and
microsoft
into
database
file
office
convert
converting
sheet
an
table
365
transfer
tables
use
as
acs
windows
10
save
tutorial
360
spreadsheets
or
of
is
possible
imports
exports
name
worksheet
for
users
exporting
adding
move
entire
columns
job
costing
make
program
permission
input…(read more)
Convert Word 2 PDF: Word to PDF Converter
Convert PowerPoint 2 PDF: PPT to PDF Converter
Convert Excel 2 PDF: Excel to PDF Converter
Convert an Image 2 PDF: Image to PDF Converter
Convert HTML 2 PDF: HTML to PDF Converter
More Tools: PDF Converter
Thanks you very much sir.
Can I import one spreadsheet into Access, then later, add columns to the table that it makes? AND Can I later make a different table and link data from one column in one table to data in another column in the other table. Can an Access DB grow in this manner? Sorry to be a stranger asking questions. Thanks for the video. I'll start watching your other videos. Thanks again, B.
thank you good sir a big help
I'm getting this error message when trying to import an Excel xls. file into DB 2016:
Import Error: The wizard is unable to access information in the file ‘<filename>’. Please check that the file exists and is in the correct format.
I'm not sure how to resolve this issue when the file is already in the correct format. The funny thing is, this file was exported from a table that I started in DB. I exported it, added a little data and tried import it but it won't take its own file…I didn't change anything in the file other than adding a couple of records.
I just lost all of my data from my excel file
Thank you for your post and appreciate it!
man i could not figure out why my excel file wasnt appending to my table. until i patiently watched your video and you said you have to spell it right. turns out i misspelled some words and mixed up some things. thank you so much man.
I appreciate the efforts you do to make these concise and apt videos. More to come from you…….Great work
Thanks
At the 1:48 mark when you are choosing your files, can you highlight and import multiple Excel files?
so what if you already have data but might have new data in the excel form and you just want to update the access database without duplicating information that was already updated prior, can that be done?
I am doing an append and getting a script out of range is that due to the headers?
thank you so much, i'm 17 and still have no idea. embarrassing but thanks so much lol
Great videos, if is possible can you do a series on creating a simple Vehicle Maintenance Access database, to keep track of repairs or maintenance, gasoline usage, etc, I haven't found one in the web or in youtube. Thanks
Hi, i used Access back when i was in college, but at work im getting back into it as it should be easier than excel for our data analysis. I'm struggling to get my monthly data to import to the same table. Each month i will have additional new customers and right now i have customer name as my primary key. During my import from excel into an existing table, Access provides an error message stating # records lost due to key violations. Do you have any suggestions on how to best upload data monthly and what to select for a primary key?
Thanks your videos are super great!
Thank you so much professor this has been really helpful you saved me a lot of time.
sir, how can I get this Microsoft access database from my pc it is not shown anywhere on my pc
How do import the excel data into an existing table but overwrite the entries so that up-to-date data is in the table? Some background: I have an excel sheet with all my data and the data changes every month so I would like to overwrite the old date and insert the new data,.The headings remain the same it's just the data that changes.
Best tutorial Professor Morgan!
Hello Professor. I am following step by step and for some reason I am not able to append one Table with another. Is there anyway we can communicate via email or directly ? Thx.
Then, how to make its table and Form from this datasheet?