To export data
1
Go to the File menu and choose Import/Export Assistant. The
Import and Export Assistant window appears.
2
Select Export data and click Next.
3
Select the type of data you want to export from the Export list. If
additional options appear in this window, you can complete them
to filter the data that will be exported. Click Next.
4
Select whether the data in the exported file should be separated
using tabs or commas, and whether the first row in the file should
display the field headers. Click Next.
5
Choose the fields you want to export and the order in which you
want to export them. To do this, click on the first field you want to
export in the Available fields column and then click Add. The field
name will appear in the Fields to export column.
NOTE:
Required fields for importing and exporting data When
you import or export data, certain data fields must have valid
matching fields in the target software.
If a field has an asterisk (*) next to it, you must select a matching field
to it. If two fields have a caret (^) next to them, you must select a
matching field to one or both fields.
6
Repeat the previous step for each field you want to export.
If you want to remove a field’s name from the Fields to export
column, click its name and then click Remove. If you want to export
all the fields, click Add All.
7
If you want to change the order in which the fields are exported, select the field you want to move and then click the up or down buttons.
8 When you have selected the fields, click Export.
9 In the Save As window that appears, enter a name and location for the export file and click Save. The data is exported and saved as a text file.
10 When the data has finished exporting, click Close.
0 komentar:
Post a Comment