Loading Data
Data Bridge Pro offers three ways to load data from your database into Excel: the Visual Query Builder, the AI Query Assistant, and direct SQL entry.
Method 1: Visual Query Builder
The easiest way to create queries without writing SQL:
- Click Data Bridge → New Query → Visual Builder
- Select your connection from the dropdown
- Click a table to add it to your query
- Check the columns you want to include
- Add filters by clicking the filter icon
- Click Run Query
Method 2: AI Query Assistant
Describe what you want in plain English:
- Click Data Bridge → New Query → AI Assistant
- Type your request: "Show me all orders from last month over $1000"
- Review the generated SQL query
- Click Run Query
AI Providers: Data Bridge Pro supports Claude (Anthropic), GPT-4 (OpenAI), and Azure OpenAI. Configure your preferred provider in Settings.
Method 3: Direct SQL
- Click Data Bridge → New Query → SQL Editor
- Select your connection
- Type or paste your SQL query
- Press Ctrl+Enter to run
Query Options
| Option | Description | Default |
|---|---|---|
| Row Limit | Maximum rows to return | 10,000 |
| Timeout | Query timeout in seconds | 60 |
| Include Headers | Add column names as first row | Yes |
Refreshing Data
To refresh already-loaded data:
- Click anywhere in your data range
- Press Ctrl+Shift+R
- Or click Data Bridge → Refresh