LabelMark 3 User Guide
64
Importing
Files
Data Import Types
You can import the following data types into your label file (see
Importing Data into Label Files
):
•
Text
– An ASCII text file consists of alphabetic and numeric ASCII characters. Individual pieces
of data (or fields) are delimited with a character such as a comma. A carriage return marks the end
of each line of text (or record). The following is an example of a comma-delimited ASCII text file:
•
Excel
™ or
Lotus 1-2-3
™ spreadsheet
– A
Microsoft® Excel
™ or
Lotus 1-2-3
™ spreadsheet
consists of a heading row followed by the import data. The import wizard allows you to select the
specific worksheet to use if there is more than one in the file. The following is an example of an
Excel
™ spreadsheet:
Note:
When importing a
Lotus 1-2-3
™ spreadsheet, first save it as a WK1, WK3 or WK4 file.
Lotus 1-2-3
™ versions after WK4 are not recognized. If you cannot save to an earlier version,
save your data as a delimited ASCII text file and import it as text.
•
Other data source
– The
Other data source
option allows you to import data from virtually any
database or data source (see
Importing Data From a Database
).
Importing Data From a Database
To import database data (as opposed to ASCII text or spreadsheet data) into your label file, you will have to
perform a few additional steps to connect to the database.
To connect to a database file:
1. Follow the first 3 steps of the
Importing Data into Label Files
process.
2. On
the
Importing External Data
dialog, select
Other data source
as the type of data source.
3. The
Data Link Properties
dialog appears. Click
Help
for additional assistance if required. Select
the appropriate
OLE DB Provider
and click
Next
. For example:
To import a
Microsoft® Access
™ database, select
Microsoft Jet OLE DB Provider
To import a
Microsoft® SQL Server
™ database, select
Microsoft OLE DB Provider for
SQL Server
To use an
ODBC data source
, select Microsoft OLE DB Provider for ODBC Drivers
Содержание LabelMark 3
Страница 1: ...LabelMark 3 User Guide...
Страница 2: ......
Страница 6: ......
Страница 16: ......
Страница 52: ......
Страница 58: ......
Страница 86: ......
Страница 88: ...LabelMark 3 User Guide 82 Symbols Guide...
Страница 89: ...Symbols Guide Symbols Guide 83...
Страница 90: ......