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

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

Thank you, Professor Morgan. Great videos.

Hi Morgan, I would like to make the price list of parts with 7000 items in access with front page to put the part number only and get all the price and other details in the excel format and then make a list and export to excel, Do let me know we can do

How do i populate a table with the data in another excel table

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

I would like to create a search Gui for my database.

really helpful 👌🏼 👏🏼

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

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

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?

Awesome!!!!! THANKS!!!!!!!

Thank you so much my man!

his ram on steroids

cOOL!

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!

Excellent ... simple and to the point

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

Awesome bro 😎

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

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 😅

Hi. What are indexes? Is it important to know about them in terms of import? Thanks in advance

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

This video helped a lot. Thanks

This helped so much thank you

Thank you for making it so simple. Helped me

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.

thnx u so much for explanation

Good stuff

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

THANK YOU SO MUCH FOR THIS INORMATION

How to change acess 2013 to 2016 plz tell in reply not in next video

Hi Professor,
I have a query from an Access database exported to Excel (so i can manipulate the data) and then a link from that excel file back to access. The problem i am having is that the data going back to access doesnt refresh unless i open and close the excel file. I have changed the setting for refresh in excel under the query and the external data menues but it still wont auto refresh. What can i do to accomplish auto refresh without having to manually open excel?

Nice job staying on point while explaining in sufficient detail.

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