Microsoft Access 2010 Tutorials
External Data / Importing Data
Visitors to VTC.com will be able to view all introductory videos for each training course.
Free Trial Members will gain access to first three chapters for each training course.
Full Access Members have full access to VTC.com�s entire library of video tutorials.
Learn More
Subtitles of the Movie (Microsoft Access 2010 / External Data / Importing Data)
Importing data into Access 2010 from outside sources is also very easy, as far as the steps required, but you'll have to play with it a few times, do a little trial and error, to make sure that you're getting the data exactly the way you want it. Now let's do an import here, and take a look at the steps. Notice I'll open Access 2010, I will click on External Data, and in the Import Section, notice that I can import from a text file. Now keep in mind, and let me come down here and let's go out to the documents folder, and if you remember we have a students text file out here, that we exported to in the video entitled Exporting Data. So if you haven't seen that, go watch that video, and you'll see where this data came from. So this is what we exported out. Now let me close this just a second, and go into Access, and if I double click the students table, notice this is what we exported out. And so we went down through student ID eight. Well what I want to do here, is I will close this table, I will jump back out here, and open the students, and I am going to add one more line OK? And I'll show you a good thing that, a good example, of how we can import data, so if somebody just in a raw form, creates data, and I'll do my best to hurry here, OK? Do another Fairview here, so we didn't have one of those. Add those in. Whatever that zip is, it's probably not right, and Mark at Mark.com, separate that, and put a phone number in, there we go, a very creative phone number. So notice this line right here, was not what we exported that. This is a new addition, and so it's possible to add data to these comma separated text files, and if I did it correctly, and the formatting is all correct, it looks good for the quick glance here, I can close this, and I'm going to import this into a table in Access OK? And so what I will do, is go to Import Section, click on Text File, and it says tell me where the data is, specify the source of the data, I'll click Browse, I will jump out there. There is my students text file, notice it's looking for text files, double click that, I've loaded it up. Now it's asking me for some questions here. Import it into a new table in the current database, or append a copy of the records to a table that's already there, or I can create a linked table, we'll look at that a little bit later on alright? I'm going to import it into a new table, watch how cool this is. I click OK, I get the same preview that I did on export, this is what it's looking like. I can hit Next, it's comma separated data, show me what it's going to look like in my table here. If my data has row names, or field names, column names on the top, it's going to try to read them there. It does not, and so I'll hit Next, and then notice, it can't read since I didn't pass any field names in, it don't know what the field names are OK? So I can choose the first column here, and change that to SID, then choose the second column, and I know that it's IID, and I'm just going from memory here, OK? And I can change this one, to L Name, right? F Name, and I can set whether it should be indexed, because I'm loading raw data into a table OK? Or I can tell it don't import certain fields, if I don't want to import the address, I can click that, and it won't bring it in. Alright, so I can just check these, click on these, and do what I want OK? I'm just going to leave those re-named, and then I will click Next, and then it's going to ask me, do you want to set up a primary key as you do this? And I can say sure, I'll choose my own, it's going to default to SID for me, I'll say that's cool, so not only will this load the data into an Access table, but it will also set the primary key for me. Then I hit Next, and I'm just going to add this into Students import, as the name of the new table, I hit Finish, and I want you to notice what happens. It wants to know do I want to save this? The import steps, I'll say no for now, close it, and boom, there is the students import table. So notice this is now a table in my database, and then notice, right here, this is the record that I added out in the text file alright? So pretty cool stuff, very easy to import, notice how I re-named my fields up here, notice we re-named SID, IID, L name and F name, and then we stopped, and so it just took the generic fields. So what I'll have to do now, is just come in here, and change these right? Just like that. So I can go change every one of those if I would like. That's a very easy way to grab data from some other source, get it into your Access environment, and now it's there, as a table inside your Access environment, and you can manipulate this, as you see fit alright? So that's how to import data. Keep in mind, you can import from Excel, you're just going to get a little bit different Wizard that you're going to go through here, on the various files that you import from. But you're going to do the same thing, you're going to browse out, point to the file, tweak the data, import it, and you're done.
Tutorial Information
| Course: | Microsoft Access 2010 |
| Author: | Mark Long |
| SKU: | 34224 |
| ISBN: | 1-936334-91-7 |
| Release Date: | 2011-05-12 |
| Duration: | 9 hrs / 121 lessons |
| Work Files: |
Yes |
| Captions: | No |
| Compatibility: |
Vista/XP/2000, OS X, Linux QuickTime 7, Flash 8 |
VTC Sign up & Benefits
- Unlimited Access
- 81,350 Video Tutorials (14,200 free)
- Video Available as Flash or QuickTime
- Over 715 Courses
- $30 for One Month Access
- Multi-User Discounts Available
