Excel 2016 - Import to Access - How to Export from Microsoft MS Data to Database - Transfer Tutorial

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
KZbin 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 KZbin 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

[@goawayimbaitin1278]

As someone who is frantically watching your videos during my timed integrated word/excel/access project, thank you oh Microsoft gods 🙏🏻🙏🏻🙏🏻

[@elonal2410]

you just saved 10 students their lives, thankyou legend 🤍👌👍

[@zahidul999]

Keep doing all the good works, sir it helps lots of students. Thank you, sir.

[@ProfessorAdamMorgan]

Hey thanks Kazi, I'm always happy to help. Thanks for watching and for the comment, have a nice day!

[@kayla-cf9dq]

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.

[@salaheddineelkhattabi2640]

You saved many lives today my brother!!! Da wordt ne traktatie op foubert eh moatt 👍

[@elonal2410]

kom mij trakteren a broeder

[@earthangel5587]

Nice job staying on point while explaining in sufficient detail.

[@angelinafranco1469]

Hi, Professor Thank you so much for this video! I am having trouble Importing my file, but thanks to your video I think I got it.

[@ProfessorAdamMorgan]

No problem Angelina, thank you for watching. I'm glad you were able to import your file, have a nice day!

[@prashantkumarvashista9701]

I appreciate the efforts you do to make these concise and apt videos. More to come from you.......Great work Thanks

[@saifwahba3536]

Thank you so much professor this has been really helpful you saved me a lot of time.

[@IsNgUp01]

short and to the point like videos like this should be.

[@ProfessorAdamMorgan]

I agree, IsNgUp01. Thanks for watching!

[@dyanachan2790]

thank you for the video. I'm having trouble in creating a database for my calibration lab and this video is really helpful for me.

[@ProfessorAdamMorgan]

Hey I'm glad this has been helpful for you Dyana! Thank you for watching and best of luck creating your database.

[@PHYCHOLOGICAL1337]

This was extremely useful to convert information from Google Forms to Excel and then to Access. Thanks!

[@ProfessorAdamMorgan]

Hi Phychological, Yeah, luckily those 3 programs all work pretty well together so I'm glad this worked for you. Thanks for watching!

[@markjegugu8723]

U really know how to explain...,I loved the video and I have gotten the concept,,thank you so much

[@thefathersdaughter4710]

This was super helpful. Im taking a course and didn't understand Access and your video was great. Thank you.

[@ProfessorAdamMorgan]

Hi Michele, Great, I'm glad my video was helpful for you. Let me know if you have any other questions in your course.

[@gregclancey6972]

Great video. If your getting "subscript out of range" error each time you try importing from a worksheet to a table -- try the radio button for new table instead. It worked for me. I got that notion about 4 seconds into this great vid after being frustrated all night trying one idea after another. Looking for solutions that would fix the "to a table" import problems was humiliating and antagonizing.

[@ProfessorAdamMorgan]

Hi Greg, Thank you for posting your problem and solution. I hope you have a nice day.

[@merrymeri4700]

I am having this same problem, I’ll try that. Thanks

[@gregclancey6972]

@@merrymeri4700 Good luck. It still works for me.

[@severinojoaquim]

All right, man! Thank you for your attention.

[@ProfessorAdamMorgan]

No problem Prof. Joaquim, thank you for watching!

[@sabrinasilver-rose9731]

Thank you so much. Even though this was not for me, it still helped.

[@ProfessorAdamMorgan]

No problem Sabrina, I'm glad you found it helpful. Thank you for watching.

[@keithers7029]

Dude! Nice job on cutting through the muck and teaching an otherwise sermon to a quick text with an emoji at the end 👌🤣👍 well done sir!

[@tyroneharding5796]

Hi, My name is Tyrone and Love your videos. At age 60 am deciding to build a database in Access. After building a Table 30 fields am having problem importing pdf files or text files in to my present Table in Access and also will like to update and keep the previous data for records to look at. Thank you

[@alicramazan]

Thanks man. I realized where I was doing wrong when I watched this.

[@ProfessorAdamMorgan]

No problem Ramazan, glad this video helped. Thanks for watching!

[@shahin2324]

Clear and concise!!! Thanks a lot!!!

[@ProfessorAdamMorgan]

No problem, Shahin. Thank you for watching!

[@niveus73]

Thank you very much. Your video explained exactly what I was looking for. Thanks!

[@uptonictv]

Thanks so much for this video. It was actually a help for me. I was trying to append an excel file into my access table but I was clicking excel under Export instead of under Import & Link.

[@ProfessorAdamMorgan]

I'm glad this helped you out, Upton Kanei. That's an easy mistake to make. I'm glad you got it figured out.

[@katboyum3054]

Thank you for this video! I was having trouble importing from excel for my CIS class and this was really helpful.

[@ProfessorAdamMorgan]

No problem, Kat. I'm glad this helped you with your CIS class, thank you for watching.

[@vivivioleta9260]

Very nice video tutorial, I've been search this tutorial. thank you so much. Can you make tutorial for Account Receivable with details of customer? tks.

[@scholesy1000]

nice work dude. quick and easy to understand.

[@ProfessorAdamMorgan]

Hey thanks scholesy1000, I appreciate that. Have a nice day.

[@ritachacon5832]

Thank you so much for the tutorials. It has been so helpful.

[@ProfessorAdamMorgan]

I'm glad the videos have been helpful. Thank you for watching and have a nice day!

[@rayt6867]

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

[@pronounceword]

Hi.I like your video very much. It's really great. I'll keep an eye on your channel. I am your fan and I will support you.

[@ProfessorAdamMorgan]

Thank you, pronounce word. I appreciate you watching, have a nice day!

[@naniaddis5251]

Thank you for making it so simple. Helped me

[@naviei8455]

Thank you, Professor Morgan. Great videos.

[@aruna82]

Thanks Adam!!! it was easy to upload excel to Ms Access Kudos

[@zaynaqualander3329]

This video saved me lol... thanks for your help! 🙏

[@solochanel2364]

Thank you so much professor👍👍👍

[@ProfessorAdamMorgan]

No problem, Saepul. Thank you for watching!

[@craigmackenzie3983]

Excellent ... simple and to the point

[@xAPxGoldenChild]

The nail polish is very cute

[@ProfessorAdamMorgan]

Thanks Avery, my wife had the other side of this room haha.

[@randaalawneh3940]

Hi professor Morgan! Your videos are so helpful and helped me learn a lot, thank you! I had to use Access for the first time at my job, that’s when I discovered your channel and your videos have been extremely informative and easy to follow. If it’s possible, can you make a video about macros? I’m trying to make a button that would automate Importing and exporting data from Access into Excel and vise versa (basically automating data ingestion for both softwares). I know it can be done but I don’t seem to figure out how to do it. If you can’t find the time to make a video about it, can you please explain the process or give me the formula (idk if that’s what it’s called?) for it. It’s kind of urgent and I would really appreciate it. Thanks again :)

[@randaalawneh3940]

Or maybe if it’s troublesome for you, please just direct me to a video or a website or anything that could help me achieve what I’m looking for. Thank you, and waiting for your reply :D

[@ProfessorAdamMorgan]

Hi Randa, I'm so glad to hear that my videos have been helpful for you. Access can be pretty intimidating if you've never used it before, so I'm glad you feel more comfortable within the program. Regarding Macros, I do not currently have any Macro videos for MS Access. I found a website that could help you with this, so I will link it below. Hopefully it works for you, so let me know. I may be able to make a video on this in the future, but right now I'm still catching up on other student content. Have a great day and thanks for watching! support.office.com/en-us/article/importexportspreadsheet-macro-action-9973a631-6586-4c1d-9c61-ae167696b750

[@astridsosa5362]

Great instructions! Thank you for making it so simple.

[@ProfessorAdamMorgan]

Thank you for watching, I'm glad it worked for you. Have a nice day!

[@chibi12twelve]

@@ProfessorAdamMorgan Hello Prof. Adam, how do I cross reference my data from excel to my existing database in access? I want to know if my data from excel have the same matches in access. Thank you and great video!

[@prasaditharanga8463]

Thx a lot. I'm from Sri Lanka

[@bambynaa]

You are the best! Thank you for this video.

[@ProfessorAdamMorgan]

Hey thanks for watching MarCel, I am glad you enjoyed this video. Thanks for watching!

[@soubhagyalaxmimishra4722]

Thanks a lot.... This one helped in my exam

[@ProfessorAdamMorgan]

No problem Soubhagya, thank you for watching my video!

[@mikeputerio6853]

Another excellent set of videos. Could you make a video on merging two worksheets with similar information? I have two worksheets that contain some identical fields, but other information. I would like to get that information onto one sheet. Thank you.

[@ProfessorAdamMorgan]

Hi Mike, Thank you for watching the videos and for the comment, I appreciate it. My recommendation is to export the two tables to Access, then use a Query to get just the data that you want from each sheet. Here is a video of me explaining combining multiple fields into a query: kzbin.info/www/bejne/j4jNgpaolp6XhcU

[@ibrahimabdalla1642]

Tip if you have one of the newer versions of excel make sure your clicking in the part where it says imports.

[@ProfessorAdamMorgan]

Hi Ibrahim, Thank you for adding this tip, I appreciate it.

[@archanaaa2514]

Hello thanks for sharing this video.. I am beginner to Ms access.. wat skills i must know in access as a beginner?

[@GurnBograt1986]

Best tutorial Professor Morgan!

[@laurastr1]

Thanks so much, this was very helpful at my job!

[@ProfessorAdamMorgan]

I'm happy this helped you out, Laura. Thanks for watching and have a nice day!

[@mollyreding6709]

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!

[@thebesttechnical3608]

Supper explanation and very helpful

[@ProfessorAdamMorgan]

I'm glad this helped you out, The Best Technical 360. Thank you for watching!

[@dianewang906]

Thank you for your post and appreciate it!

[@ryangonzalez2230]

This video helped a lot. Thanks

[@linhlanbui4946]

So helpful! Thank you very much!

[@ProfessorAdamMorgan]

I'm glad to hear it linhlan, thank you for watching!

[@orchidblack4205]

Helps alot, thanks.

[@ProfessorAdamMorgan]

I'm glad this helped, Elis. Thank you for watching!

[@orchidblack4205]

@@ProfessorAdamMorgan You're welcome. 😃

[@denysuhendraproject5251]

subscribed and still surfing on ur channel's videos (Access), have a great day!

[@ProfessorAdamMorgan]

Thank you for subscribing Deny, that really helps out my channel! I'm glad you're enjoying my Access videos!

[@Awed1b]

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.

[@Huancaino1000]

Thanks Professor, I am wondering if you have a tutorial on how to create and run queries.

[@ProfessorAdamMorgan]

Hi Hermann, Thank you for watching. Yes I do, here is the video: kzbin.info/www/bejne/j4jNgpaolp6XhcU

[@tfcscrewdriver]

nice easy to follow video., prof. also nice nail polish collection

[@ProfessorAdamMorgan]

Hey that is good to know Gerald, I'm glad the video was helpful. Yes, my wife loves her nail polish, glad you like it!

[@mrs.q.2309]

Yes, thank you! This has helped me a lot! 👍🏽

[@ProfessorAdamMorgan]

Glad it helped! Thanks for watching, Lola.

[@imyong7983]

Nice thanks...easy to follow

[@jenniferortizaviles7242]

This helped so much thank you

[@LWVCTEF]

Very useful. Thanks.

[@ProfessorAdamMorgan]

I'm glad to hear that J Rabinow, thanks for watching!

[@jamesleslie1650]

nice clear explanation well paced thank you

[@ProfessorAdamMorgan]

Thank you James, glad this video worked for you. Thank you for watching and have a nice day.

[@letys4637]

Adam, thank you for your video! It is very helpful. I haven't used ACCESS for over 20 years and needed some brushing up. So thankful i found your videos. However, I am coming across an issue. I am importing my excel file and it has several rows that are duplicated in columns. Such as the SSN and Name. The rest is not duplicated. Then, my file won't import. The error i am getting is: type conversion failure.. do you have a video for such error?

[@PhillipTabula]

Thanks Prof. I have got it

[@dyalahamadi2327]

Thanks for the toturial , i am trying to import an excel file but it has merged cells so what should I do to complete the task successfully and import it to access

[@ProfessorAdamMorgan]

Hi Dyala, Thank you for watching. You will need to unmerge the cells and remove any unnecessary cells from the spreadsheet. I recommend only having column headings and data if possible. I hope this helps.

[@Quiquito1960]

Hello professor I have a question how can I prevent a customers list from creating duplicate entries? BTW I want to thank you and let you know I have enjoyed watching and learning from your videos

[@ProfessorAdamMorgan]

Hi Enrique, It depends which program you'd like to remove the duplicates from. If you want to remove them in Excel, go to the Data tab, Data Tools group, then select the row you'd like to remove the duplicates from, and click Remove Duplicates. If you want to remove them in Access, make the duplicate customer field the Primary Key. If you do that, Access won't allow duplicates to be made in that field. I hope this is helpful for you. Thank you so much for watching my videos, I am glad you're enjoying them. Have a great weekend!

[@Quiquito1960]

Professor Adam Morgan I am using access 2010

[@sachingaichare4599]

very helpful, thanks

[@ProfessorAdamMorgan]

Glad it was helpful!

[@fatihasoumaiyameem3583]

It was really helpful

[@ProfessorAdamMorgan]

I'm glad to hear that Fatiha, thanks for watching!

[@jennyborgit3900]

Thank you so much my man!

[@MaelyseliaKemgo]

Yeah Sir thanks you it was helpful

[@ayangcyprianteboh4857]

Thanks you very much sir.

[@DomeShot]

This was a really easy and simple video to follow. When I tried it, it worked beautifully. Thanks a lot! BTW, I have an Excel things I'm trying to do, but don't know how to do some of the things I'm trying to accomplish. How can I get in contact with you to see if you might be able to lend me a hand with it, or just give me some pointers?

[@ProfessorAdamMorgan]

Hi Dome, Thanks, I'm glad this was helpful for you. The best way to ask me questions is through the comment section on videos. I try to respond to all comments and help out whoever I can. As for learning Excel, I already have a pretty extensive playlist that you can view on my channel, I'll link it below. Just let me know if you have any questions: kzbin.info/www/bejne/qpy2nHx9p86dhbs

[@redemepror8824]

thank you good sir a big help

[@dorisnyaguthii8972]

Very helpful indeed. Thanks Morgan!

[@ProfessorAdamMorgan]

That's great to hear, thank you for watching Doris. Have a nice day.

[@ChrisJacob-k6s]

Thanks, Pro Morgan! This is very helpful. New subscriber here :-)

[@mohammadzanhanifee8989]

Hello Sir, I it very helpful for me. Thank you so much. 😊

[@sapnarai3036]

thnx u so much for explanation

[@marlenyventura2762]

Hello Professor Adam; You are my favorite KZbin teacher that I have found. I would like to know why my Ribbon bar is not active for me to import a workbook from Excel to a table. I click on the External Data icon but the other icons are in color gray. I will apréciate your help.

[@thatomnguni9044]

THANK YOU SO MUCH FOR THIS INORMATION

[@pablorobinson4506]

Saved my life, thankyou

[@ProfessorAdamMorgan]

I'm glad it was helpful for you le gran mnu, thank you for watching!

[@hamedbakhtiari7540]

Thank you So much

[@ProfessorAdamMorgan]

No problem!

[@zainyt4185]

Bro you legend you saved my life thank you so much liked and subbed 💪👌

[@ProfessorAdamMorgan]

Hey thank you Unique. Glad the video was helpful and thanks a bunch for subscribing. Have a good one!

[@zainyt4185]

Instructor A Morgan No worries man your awesome!!

[@ProfessorAdamMorgan]

Hey thanks! Have a good one!

[@bigsam1989]

Nice video. But I seek to append just one column of data from Excel into an already existing Access table. I somehow had that field deleted from Access and now I want to import just that column. Is that possible?

[@ProfessorAdamMorgan]

Hi, Try adding in a new column (field) in Access and name it the same name as the column in Excel. From there, import the data and it should work. I hope this helps, thanks for watching.

[@chriswebb4797]

Good video, thanks

[@ProfessorAdamMorgan]

Thanks for watching, Chris. Have a nice day.

[@nicholasandsofiaflores4611]

thank you, your tutorials are very helpful. But I have a problem that I haven't been able to solve, I am a beginner in access. I have an excel file that in one column sometimes have an "enter tab in the same line" so, when I export the excel into access, access removes the enter and leave everything in that field in our single line. Ex. excel has in one field, for example A5: 1234 agbc in access it will show 1234agbc It looks like access remove the enter from the fields

[@ProfessorAdamMorgan]

Hi Nicolas, I am glad you're finding my tutorials helpful. Access reads your Excel data as text. When you have an 'enter' or create a new line in Excel, it will not recognize that change since it's a formatting change. The only way to get it to show in a new line in Access is by having it in its own cell in Excel. I hope this helps, thanks for watching.

[@raiylynmitchell5892]

thank you so much, i'm 17 and still have no idea. embarrassing but thanks so much lol

[@chetanakakade7494]

Hi Adam, thank you for this video. I have a question - How shall I Import the excel data from a particular sheet into the access if I have more than 1 sheets in the excel file?

[@ProfessorAdamMorgan]

Hi Chetana, Thanks for watching. When you get to the 2nd step of the Import Wizard in Access, you'll see all of the worksheet names listed at the top. Choose the one you want and follow the prompt as needed. I hope this helps!

[@cayladelorenzo4047]

Thanks for posting, although for whatever reason it didn't help my project. The error I keep getting when trying to import my data is, "database unrecognizable". I was able to call someone and get help, but you should do a video showing how to use the "Database Tools" button to fix a file. Also, you should do a video on how to change the Filled map in Excel if it's not showing the map you want. For example, I was trying to create a filled map of ONLY California and my excel data was of several different CA counties but it kept giving me a map of the whole US.

[@ProfessorAdamMorgan]

Hi Cayla, Thanks for the suggestion. I will look into this and post up a video. Have a great day and thanks for watching.

[@solomonadekunle2829]

Thanks for this video, it's really helpful. Though I think i have a problem with my laptop, when ever I click on the External data, it doesn't show saved import, I can only see saved export. This has made it difficult for me to import into my access. I'm using ms access 16. Pls is there anything I'm not doing? Pls help me out here.

[@jcascio9215]

Prof Morgan... the access file I am working with has data in the tables presently and is already set up with the tables tied to reports, queries, and dashboard buttons. I want to copy in data from an excel file into an existing table. Trying to save hours entering one record at a time. So when I paste these records in.. will it compromise those reports , etc.?? Thanks for your time sir.

[@ProfessorAdamMorgan]

Hi J Cascio, What I would recommend doing is saving a copy of your database somewhere else on your computer. From there, try to import the information and see what happens. Since it's a copy of the file, it shouldn't cause any problems to the original file. I doubt you'll have issues with the reports, queries, etc. but it's better to be safe than sorry. I hope this helps.

[@harmonyharold7874]

Thanks so much for the vedio.

[@ProfessorAdamMorgan]

No problem Harmony, thank you for watching!

[@mikewashington4188]

Adam, is it possible to have the linking allow updates in both directions? That is if I can update the data in access it is also updated in excel? Thanks!

[@nikhil-eu3mi]

Same doubt here

[@sambulakatanekwa1974]

I have really enjoyed the tutorial.send me some videos hw to create dat on-line system for a small school.katanekwa Sambula in Zambia

[@severinojoaquim]

Helo, man! When we transfer data from one Listview1 to another (Listview2, in a different form, as checked by checkbox), how to send Listview2 data to a DB Access table? Many thanks for the excellent tips given.

[@ProfessorAdamMorgan]

Hello Prof. Joaquim, Typically errors in transfer occur when too much formatting happens in Excel. For Excel, just think text-only formatting. Any charts, formulas, things like that sometimes cause transfer errors. Perhaps adjusting the Excel sheet would improve the transfer. I hope this helps.

[@severinojoaquim]

Thank you for your attention

[@ProfessorAdamMorgan]

No problem, have a nice day.

[@natkiri]

Thank you for this easy to follow video. Unfortunately, I still get the error message when I import - The Microsoft Access database engine cannot find the input table or query. Make sure it exists and that name is spelled correctly. How do I fix this? SOS 😅

[@jaynebaker1003]

hi and thanks. can you advice how to choose few fields from excell and export it to access. thanks again

[@larreando]

Thank you Adam. What if my backend has a unique numeric identifier choose automatically by access. How to generate this number

[@TheParamedics1]

Is there anyway around importing to a current database from a Excel file that has all characters formatted correctly...but the columns are in a different order? Great vid!

[@ProfessorAdamMorgan]

Hi TheParamedics1, I'm sorry but I am a little confused by your question. Typically you can order the fields however you'd like once they're in Access. Please give me a little more information and I will try to help. Thanks for watching the video.

[@TheParamedics1]

Professor Adam Morgan Wow, thanks for the quick reply! Apologies if my terminology is incorrect, my situation is I have a Access database linked to a website that houses ticket records for that are distributed and worked at my job. These records are currently being mass imported from an Excell table via copy paste from the table to Access by selecting the New empty row below current data in access table. The excel file the table is copied from is formatted accordingly by text and column order or else it will not take the data and cause an error. The raw data that is filtered to create the final report in excel has extraneous data and columns. My current workaround to clean up prior to Access import is a formula to dump the data in a template excell that will automate the correct formating and order for access importing to another sheet in excell. Is there a faster workaround to obtain the correct formating, specificly only taking certain columns needing for import to access? The text is in correct format without an issue, but I need a faster way to format or get access to take the incorrect column order. Apologies for the long post, hard to explain jajaja 😂

[@ProfessorAdamMorgan]

No problem, I'll do my best to help here but it's kind of difficult to do over text without seeing the actual document. Linking the data to Excel is not always the best option since if the Excel file is lost, moved, or changed, it can effect the data that it is linked to. I guess the question I have is why not just add the ticket information directly to Access in the first place. If you get it into Access from the start, it will fix the linking issue. I'm not sure how much data is contained in the columns, but if it is not too much to be manually typed, that is always an option. It seems like your current copy and paste method takes time, but works correctly. I'm just wondering what is the point of using both programs as opposed to one or the other. Let me know.

[@dollarz999]

Please help me with a video on computation of parameters

[@francewise3158]

Can you please make a tutorial on my case where i have excel and word standard blank forms which i wanted to import in access. I have the table of informations too from excel so that it will automatically fill in the blank forms as i print it. Hope you will help me. Thank you

[@ProfessorAdamMorgan]

Hi Franciose, I'm sorry but I do not know of a way to do that. Since the form style on Word or Excel isn't standard, Access would have a hard time formatting your information into a table. My recommendation is to convert the forms to a table in access and create forms and reports from that table that you can print out. I hope this helps, thanks for watching!

[@r-2024-b8p]

it was very helpful thank you so much

[@ProfessorAdamMorgan]

Hi Roqiyah, No problem, I'm glad you found the video helpful. Thanks for watching and have a nice day.