Set up a data source that uses the Microsoft text driver

Microsoft Query

Show All

Set up a data source that uses the Microsoft text driver

You'll need to set up a separate data source for each folder that contains text files from which you want to access data. If you want to use the data source to access data simultaneously from more than one text file, copy all of the text files to the same folder before proceeding with these steps.

  1. If the Create New Data Source dialog box is not displayed, click New on the File menu, click the Databases tab, and then double-click New Data Source. Type a name for the data source in step 1 and select Microsoft Text Driver in step 2.
  2. In step 3, click Connect.
  3. If the text files are not in the current directory, clear the Use current directory check box, and then click Select Directory to locate the folder.

Note   You can gain access to data in text files in several formats, including columns separated by blank space or by commas or tab characters. For more information about the text file formats that you can use, click Help in the ODBC Text Setup dialog box.