![]() |
|
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. Business - Directory of business/finance/loan/mortgage related partner sites Computers - Directory of computer hardware/software/peripheral related partner sites Internet - Directory of webhosting/webdesign/internet marketing related partner sites Software - Directory of software related partner sites Web Design - Directory of web design/development related partner sites Web Hosting - Directory of web hosting related partner sites Web Promotion - Directory of search engine optimization/internet marketing related partner sites Web Resources - Directory of other web related partner sites Recreation - Directory of travel/hotel/cruise related partner sites Casino - Directory of online gambling/poker/blackjack/roulette related partner sites Health - Directory of online pharmacy/hospital/health related partner sites Shopping - Directory of online shopping/gift related partner sites Miscellaneous - Directory of all other partner sites
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. |
Partners |