Hi and welcome everyone. Today we have a video request from je r. Je r says, "I'm having trouble importing Excel files from my computer. It just says error. I don't know if it's my computer or if I'm doing it right. Can you make a video on it, please?" Alright, J here, so I'm going to make that video right now. I'm not sure if you're importing the files to your Access database to a current table or to a brand-new table, so I'm going to show you guys how to do this both ways. Alright, so right here we see an Access database. All I have is one table in it. So, I want to get my excel file into this Access database. This is the excel file that I created. It's pretty standard. Whenever you take an excel file and put it into access, it doesn't really need any formatting on it, right? Because Access is a database program, so you could basically just write in whatever data you need with all of the excel data for default formatting and it should be ready to go, right from there. So, I'm going to take this file here and I'm going to put it into an access table. I'm going to close out of this right now. You need to make sure that your excel file is currently closed. And then, what I'm going to do is I'm going to go into my access area and I'm going to go to the external data tab. So, you click on external data. And to move Excel into there, you go to import and link, right? Because import means it's coming into the Access database. And so then, I'm going to choose this icon right here for excel. So, I click on...
Award-winning PDF software
Video instructions and help with filling out and completing Fill Form 8815 Import
