Article Sphere Logo

Importing your Text Files Into Microsoft Access

By Expert Author: Sezer Bozkurt | Article Abstract
Word Count: 323 words | Views: 55 view(s)
Most of us have documents spread over several type of files such as excel spreadsheet, text files, PDF's and more. Consolidating these files into an organized Microsoft Access Database may seem difficult at first, but I will show you it's quite simple.

Firstly you will need to know where your text file is saved. Once this is done open up your access database. If you don't already have an access database open a blank database and save it onto your hard drive.

Once this is done look at the blank screen when the "tables" tab is clicked on. Right click on the blank screen and select "import". Once this is done you will get a browse screen to select the file you want to import. Change the file type from access mdb to text file. Then the screen will show you all the text files that are available. Double click on the text file you wish to import.

Once this is done you will need to run through the wizard to determine the way you want the data from the text file to be organized. You will need to select things such as the delimiter (the character that will divide your columns), which fields you wish to import and the data types you want those fields to be. This is quite simple and should only take you a couple of minutes.

Once you click finish access will bring up a message saying your table has successfully been imported. If there were problems during the import process these erroneous records will be pasted into another table in your database. The default name of this table is "paste errors". These errors are usually due to the data types you specified so it pays to go back over your import process and see what might be causing the problem. Looking inside the "paste errors" table at the erroneous records will give you a good idea of what went wrong.
Sezer Bozkurt

About the Author/Author Bio

For great reviews on Plasma Television models visit our Plasma Television website

Article Source: http://www.articlesphere.com/Article/Importing-your-Text-Files-Into-Microsoft-Access/20035

Article Tags: data, access

Article Submitted: 2006-04-09 | This Article has been viewed 55 times.

Rate Article

Related Videos

Adobe Photoshop CS2 - How to Access and Purge Cache Files
How to Gain Easy Access to Most Used Files in Nautilus
How to Compact a Database in Access 2007
Access MobileMe from your iPhone
How to Use the Attachment Data Type in Access 2007
 

More "Personal Technology" Related Articles

 
 

Listed below are more articles related to the above article from the "Personal Technology" article category.

People interested in the above article "Importing your Text Files Into Microsoft Access" are also interested in the related articles listed below:

 
With the increasing popularity of the iPod, it only stands to reason that the accessories market is growing right along with it. Often referred to as the iPod ecosystem, the large number of available iPod accessories are designed to work directly with the iPod and are manufactured by a variety of different companies. Well known industry music leaders Bose and Kennsington are among the companies to create iPod speakers, which use the iPod's third pin dock connector. Various other companies create add-ons that permit the iPod to record sound, recharge, experience playback music on the radio and create wireless capability for the iPod to be operated with the use of a remote control.
Rumors have been circulating for a while now that Google is developing its own Android-based handset. The Wall Street Journal reports that the rumors are confirmed and that Google employees are currently using a prototype of the Google device, which will be dubbed the Nexus One.
If you are a layman who is just starting on buying on his first camcorder and humbly wish to only have device with which to record your memories, a list of imposing features can completely blow you out. Here is a quick understanding of basic specifications of camcorders so that it may not remain as technically scary as it seems and you get to know what to look for in which one.
Every conversation has rules. We know not to interrupt someone when they're talking. We know not to use bad language when we talk. We know not to talk too loudly. And we know too how and when to break all of the rules. Exactly the same is true for a Twitter conversation. The site hasn't been around for long, but Twitterers have already tried to figure out something like a Twittering etiquette.
Not so long ago, if you wanted to listen to music while on the move you would have to carry around a chunky portable CD player, a large set of headphones and a case full of CDs. However, these days all you need is a small iPod weighing considerably less than the portable CD players used to.
Bluetooth technology is becoming increasingly popular in the world of electronics, both for the home and office environments, and even on the road. Bluetooth technology can be found not only in hands-free headset devices for your cell phone, but also in printers, computers, laptops, entertainment systems and more. With the increase in electronic and technology products we use in our daily lives, it is no wonder we would all like freedom from wires. Bluetooth is one technology that does just that.
Music is loved by people all over the world, irrespective of language and in different forms and when it is feasible to listen to music even while on the move it becomes all the more appealing. The pioneers in the field of iPod-the Apple Inc. have made it possible by devising one small device, the iPod shuffle that has taken the music lovers by storm.
 
Article Directory Home All Categories Computer And Technology Personal Technology
 

Can't find what you're looking for? Try Google Search!
 
Copyright © 2005 - by Larry Lim, Singapore - Article Search Engine Directory at ArticleSphere.com™
All Rights Reserved Worldwide. All Trademarks and Servicemarks are the property of the respective owners.

Afrikaans Albanian Arabic Belarusian Bulgarian Catalan Chinese (Simplified) Chinese (Traditional) Croatian Czech Danish German English Estonian Filipino Finnish French Galician Greek Hebrew Hindi Hungarian Icelandic Indonesian Irish Italiano Japanese Korean Latvian Lithuanian Macedonian Malay Maltese Dutch Norwegian Persian Polish Portuguese Romanian Russian Serbian Slovak Slovenian Spanish Swahili Swedish Thai Turkish Ukrainian Vietnamese Welsh Yiddish