- #MAIL MERGE FROM EXCEL TO PUBLISHER 2010 DRIVER#
- #MAIL MERGE FROM EXCEL TO PUBLISHER 2010 FULL#
- #MAIL MERGE FROM EXCEL TO PUBLISHER 2010 WINDOWS#
The data is imported and you are finished. In the Select Directory dialog box, locate the folder that contains the text file that you want to import, make sure that the text file appears in the list below the File Name box, and then click OK.įor more information about different options in the various dialog boxes, click Help.
#MAIL MERGE FROM EXCEL TO PUBLISHER 2010 DRIVER#
In the Create New Data Source dialog box, select Microsoft Text Driver (*.txt *.csv), and then click Finish.Ĭlear the Use Current Directory check box. In the ODBC Data Source Administrator dialog box, on the User DSN tab, click Add. Open Control Panel and then click System and Security > Administrative Tools > ODBC Data Sources (32-bit) or ODBC Data Sources (64-bit). csv file, you can use a Schema.ini file to specify the correct file format. If your text file is a comma-separated values (CSV) file that does not use the list separator character that is defined on your machine, or if your text file is not a. Second, import the text file by using the user DSN. First, if necessary, define a user DSN on your computer for the ODBC text driver. Importing a text file by using an ODBC driver is, at minimum, a two-step process. The following sections show common examples for using the Schema.ini file.Įxample: Specify a semicolon character ( ) as the delimiterĮxample: Specify a tab character as the delimiterįormat=FixedLengthCol1=ShipperID Text Width 11Col2=CompanyName Text Width 40Col3=Phone Text Width 24 On the first line of the Schema.ini file, type the name of the text file that you are linking to, surrounded by brackets.Īdd additional information to specify the different text file format. Store the Schema.ini file in the same folder as the text file that you are importing. In general, to use a Schema.ini file, you must do the following:
#MAIL MERGE FROM EXCEL TO PUBLISHER 2010 WINDOWS#
Use a Schema.ini file to specify a different list separator character or text file formatĪ Schema.ini file is a text file that contains entries that override default text driver settings in the Windows registry. Optionally, to make the connection file more discoverable, you can enter additional information in the Description, Friendly Name, and Search Keywords boxes. To change the folder location, which is the My Data Sources folder by default, click Browse. odc file in the File Name box, and then click Finish. In the Save Data Connection File and Finish page, enter a name for the. In the Select Database and Table page, under the Name column, select the text file that you want to import, and then click Next. If you receive the message "Test connection succeeded", click OK. If you receive an error message, recheck the values that you entered in the previous steps. To ensure that you entered the correct information, click the Connection tab, and then click Test Connection. If the text file does not have column headers, enter Text HDR=No.
If the text file has column headers, enter Text HDR=Yes. In the Property Value box, enter one of the following: To help you locate the folder, click the Browse button next to the box.Ĭlick the All tab, select Extended Properties, and then click Edit Value.
#MAIL MERGE FROM EXCEL TO PUBLISHER 2010 FULL#
On the Connections tab, in the Select or enter a database name box, enter the full path to the folder that contains the text file. On the Provider tab, select Microsoft Jet 4.0 OLE DB Provider, and then click Next. The Data Link Properties dialog box appears.įor more information about different options in the various dialog boxes, click Help. In the Welcome to the Data Connection Wizard page, click Other/Advanced. odc file, click New Source, and then follow each step in the procedure. The data is imported, and you are finished. In the Select Data Source dialog box, do one of the following:
Import the fileĬlick Mailings > Select Recipients > Use Existing List. csv file that does not use the list separator character that is defined on your machine, or if your text file is not a. Importing a comma-separated values (CSV) text file (.csv) is straightforward.