|
|
|
Amazon.com
|
 |
|
|
|
|
|
|
|
Microsoft Access 2007 Tutorials for beginners |
|
|
Welcome to MS Tips and Tricks |
Welcome to MS Tips and Tricks -
You are at the right place if you need tutorials for beginners - Online Microsoft Access tutorials for beginners, covering the following categories
- Databases, Customization, Table, Forms, Queries, Reports, etc.,
|
Microsoft Access Tips and Tricks for beginners |
|
|
| |
| 20) The Get external Data wizard will appear. Browse for the file to import and select the Append a copy of the records to the table
option. Select the Areas table. |
| |
|
| Illustration 10: Get external data wizard. Click here to view larger image. |
| |
| 21) Once selected the file and table, press the OK button. The wizard to configure the data import will appear. |
| |
|
| Illustration 11: Automatic field's delimiters screen. Click here to view larger image. |
| |
| Our imported file is a semi colon separated values text file. Then, we live the Delimited option as is. |
| |
| 22) If you need to configure more options, press the Advanced . button. |
| |
|
| Illustration 12: Advanced field's delimiters screen. Click here to view larger image. |
| |
| Here, you could set up the language collation, the code page, date and time options and the skipped fields (useful when you do not want to import the
entire file). |
| |
|
|
| |
|
|
|
|
|
|
|
|
|
