Import external data
PhraseExpress can import bitmaps, text files, MS Excel spreadsheet or CSV files or 3rd party text expander software files.
You can import the entire file into the phrase database, import the contents into a phrase or generate individual phrases out of each line of the source file:
The data can either be imported into the phrase database or dynamically linked.
You can also create phrases based on Microsoft SQL, FirebirdSQL, MySQL, SQLite or Microsoft Access database queries.
Microsoft Outlook E-Mails can be analyzed for frequently used phrases which can then be imported as phrases for use in PhraseExpress.
PhraseExpress can also dynamically embed specific items from a file/database, such as Excel files spreadsheet cell contents or the result of an SQL database query into a phrase.
Word/Excel/Outlook import requires a local Word/Excel/Outlook installation.
Table of Contents
- Installation
- Getting started
- User interface
- Create phrases
- Edit phrases
- Insert phrases
- Manage phrases
- Macro functions
- How macros works
- Adding a macro
- Date and time
- User input
- External Data
- Automation
- Output
- Programming
- String operations
- Clipboard
- Keyboard layout
- Extra features
- Document Generator
- Clipboard Manager
- Artificial Intelligence
- Use on the road
- Gender-O-Matic
- Last used phrases
- Autocomplete
- Spelling
- Capitalize first letter of sentences
- COrrect two initial capitals
- Calc-As-You-Type
- Usage statistics
- Temporarily disable PhraseExpress
- Operating error prevention
- BrowserSearch
- Prevent unwanted interaction
- Sharing phrases
- Cloud/NAS synchronization
- SQL Server
- Benefits
- Limitations
- Installation
- System Requirements
- SQL Client Manager Installation
- Configuring an existing SQL Server
- Microsoft Azure SQL
- Windows clients Installation
- Mac clients Installation
- Upgrade
- Switching from PhraseExpress Server
- Switching from a stand-alone installation
- Switching from a portable installation
- Moving a phrase file to a SQL database
- Moving SQL databases
- Configuration
- Backup
- Uninstallation
- Troubleshooting
- Work with phrase files
- Import external data
- Licensing
- Update check
- Uninstallation
- Settings
- Reference
- Troubleshooting
Table of Contents
- Installation
- Getting started
- User interface
- Create phrases
- Edit phrases
- Insert phrases
- Manage phrases
- Macro functions
- How macros works
- Adding a macro
- Date and time
- User input
- External Data
- Automation
- Output
- Programming
- String operations
- Clipboard
- Keyboard layout
- Extra features
- Document Generator
- Clipboard Manager
- Artificial Intelligence
- Use on the road
- Gender-O-Matic
- Last used phrases
- Autocomplete
- Spelling
- Capitalize first letter of sentences
- COrrect two initial capitals
- Calc-As-You-Type
- Usage statistics
- Temporarily disable PhraseExpress
- Operating error prevention
- BrowserSearch
- Prevent unwanted interaction
- Sharing phrases
- Cloud/NAS synchronization
- SQL Server
- Benefits
- Limitations
- Installation
- System Requirements
- SQL Client Manager Installation
- Configuring an existing SQL Server
- Microsoft Azure SQL
- Windows clients Installation
- Mac clients Installation
- Upgrade
- Switching from PhraseExpress Server
- Switching from a stand-alone installation
- Switching from a portable installation
- Moving a phrase file to a SQL database
- Moving SQL databases
- Configuration
- Backup
- Uninstallation
- Troubleshooting
- Work with phrase files
- Import external data
- Licensing
- Update check
- Uninstallation
- Settings
- Reference
- Troubleshooting