odc file that you just created and to accept all the rows and columns in the data source, click Finish. In the Select Data Connection page, do one of the following: 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. On the Connection 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. Note: For more information about different options in the various dialog boxes, click Help.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |