Loading Data

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:

  1. Click Data BridgeNew QueryVisual Builder
  2. Select your connection from the dropdown
  3. Click a table to add it to your query
  4. Check the columns you want to include
  5. Add filters by clicking the filter icon
  6. Click Run Query

Method 2: AI Query Assistant

Describe what you want in plain English:

  1. Click Data BridgeNew QueryAI Assistant
  2. Type your request: "Show me all orders from last month over $1000"
  3. Review the generated SQL query
  4. 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

  1. Click Data BridgeNew QuerySQL Editor
  2. Select your connection
  3. Type or paste your SQL query
  4. Press Ctrl+Enter to run

Query Options

OptionDescriptionDefault
Row LimitMaximum rows to return10,000
TimeoutQuery timeout in seconds60
Include HeadersAdd column names as first rowYes

Refreshing Data

To refresh already-loaded data:

  • Click anywhere in your data range
  • Press Ctrl+Shift+R
  • Or click Data BridgeRefresh