[MUSIC PLAYING] MR. HAMBURY: Hi, learners, good day, and welcome to our video where we are looking at Microsoft Access and specifically how to export data from Microsoft Access to another program and how to import files from another source into Access as well. So we're looking at exporting. 

Here's a typical table. And they've actually called the table Export. So how do we go about doing this? Well, when we want to export, which is what we're looking at now, you can right click on your table and you can see there's import and export. So I'm going to click on Export. I'm going to select for the purpose of this video, Excel. 

And you can see here, I'm going to specify the name and format. So first of all, I can click on Browse and I can say, well, I want to navigate and send this to the desktop. I also want it saved as Export Example. And I'm saving it as an Excel workbook. Again, file format, you can choose whatever you want over there. 

And if you want the data with the formatting, you can do that. You can put a tick in that. If you don't want it, it's fine. We can click OK. It's been done. Do we want to save the steps? We don't have to. And we can click Close. It doesn't change anything here. However, on my desktop, what do I have? There, I've got Export Example. And when I open that up, you can see there is everything that was inside of my database. 

And you see when I scroll down, I should have-- there we go-- 201 records. So that's how I've exported from Access through to an Excel spreadsheet. So now what I'm going to do, I'm going to use the exact same file that I used for exporting, and I'm going to use it now for importing. So there, I can open my table. You can see my table's still exactly the same. 

So now I'm going to right click on this table and I'm going to select Import and I'm going to say import Excel. And I'm going to navigate to a particular document. I'm going to go through to go and find the spreadsheet that I am looking for. And there it is-- Act 2 import data. It's asking me, well, search for import. 

Import the source data into a new table, into the current database. Yes, I want it to be a new table. I don't want to it to be part of this. So I'm going to import the source data into a new table. Then I'm going to click OK. Now, what's important here is that it's showing me the worksheets. 

We click on Show Ranges, but we're not interested in that. We're looking at show worksheets. Because if I want all of this information, I can actually import it as individual tables. So I'm going to click on Data, because now they're showing me that these are the three worksheets. 

So I'm going to click Next. Next. They're just verifying some details with you. You can let Access choose a primary key, where you can create your own or say no primary key, whatever you want. Click Next. And there you can see by default, the name is Data because that was the name of the worksheet. 

So if I click Finish, click Close, you can see there's my table based on the data worksheet of that spreadsheet. If I do it again, Excel, navigate to that same file, I click OK, I can now click on a different worksheet, say Sheet 3, no, there was nothing there extra. There's information. You can click Next, go through everything. 

I can then choose my own-- I'm just going to choose my own primary key. Let's say medical. No. Let's go with surname. And you can see the default name is the name of the worksheet that it was in Excel. Click Finish. You see? If there's a problem with the primary key, it will tell me. 

And click Close. But there, again, there's my two tables. And this is how we import data from our Excel spreadsheet into Microsoft Access. 

[MUSIC PLAYING]