This topic describes how to create a OLE-DB data source to connect to a Microsoft Excel XLS file for use with Endicia Professional. If your Excel data source is in XLSX format, save a copy of that data source in XLS format.
If you are using OLE-DB with Microsoft Excel data files on a network drive, you must map the network drive such that it has a drive letter designation. For more information about how to map network drives, see the Microsoft Windows Help. Search for map network drive.
The first time you run Endicia Professional, the Database Connections Setup wizard starts automatically.
Afterward, you can manually start the Data Connections Setup wizard.
Steps
The data file location and source appear in the Location area of the Create Data Source dialog box.
Otherwise, do not select the check box.
If you selected the Show the database connection string check box, the panel displays the connection string. You should not edit the connection string except in special circumstances.
Enter a name of your choice for the data source name, and click Next.
The Order Lookup Data Map window displays your data source name.
After you have specified the OLE-DB data source to use with Endicia Professional, the Create a SELECT Statement wizard runs that helps you specify the SELECT statement to retrieve data from your Microsoft Excel data source file.
Copyright © 2017 Endicia. All Rights Reserved.