Text File Connection Wizard

Text File Connection Wizard

The SaveToDB Add-in for Microsoft Excel allows you to load and refresh data from text files.

For instance, you can save a web page to your local disk and then import its data into Microsoft Excel.

SaveToDB supports the following data formats: HTML, XML, JSON, CSV, and plain text.

Connecting to text files using SaveToDB offers several advantages over standard Microsoft Excel connections:

  • Consistent connection method for different data types.
  • Ability to connect to JSON and HTML files.
  • Capability to refresh data of any type.
  • Option to add formula columns.
  • Easy codepage adjustments.

Remember, you can save the loaded data into a database using the Data Merge Wizard.

To start the wizard, navigate to the Database tab, then select Wizards, and choose Text File Connection Wizard.

For connecting to text files in other wizards, use the Gartle Text Data Provider.

Here’s a screenshot of the wizard:

SaveToDB Text File Connection Wizard

Dialog Box Elements

File
Specify the source file in this field.
You can use a path relative to the active workbook directory, allowing you to move the workbook and the file to another location or computer without issues.
Browse
Click this button to select a file.
Codepage
Choose a codepage from this list.
Date format
Select a date format from this list.
Available options are Auto, DMY, and MDY.
First row
Set the first row of the data in this field.
Parser parameters
Specify parser parameters in this field, as described in the Web Data Connection Wizard.

This website is using cookies. By continuing to browse, you give us your consent to our use of cookies as explained in our Cookie Policy.