Creating an ODBC Data Source with the Microsoft Text Driver

Article ID: 850320
Expand all | Collapse all

TechKnowledge Content

Question:

What are the steps to create an ODBC data source with the Microsoft Text Driver?

Answer:

1.) Go to Control Panel>ODBC Data Sources.

2.) Select the type of DSN you would like to create (User, System, File). Next, click 'Add.'

3.) Select Microsoft Text Driver from the list and click on 'Finish'.

4.) The ODBC Text Setup window will now appear. In this window, enter the data source name and a description.

5.) Unmark the box for "Use Current Directory." Click on the Select Directory button and browse out to the directory where the source file(s) are stored.

6.) Click on the Options button. If the extension of the file is not present in the Extension List window, it can now be added. Note if the extension of the file is not .txt or .csv a 'Read Only' error may result.

7.) Click on 'Define Format.' The Define Text Format window will appear. This is where the options for the delimiter of the file and column headings option can be marked. If the file that has fixed column widths and is not comma or tab delimited, the column widths can be set here. If it is a tab or comma delimited file, the column widths do not need to be specified.

8.) Click 'OK' until back on the Control Panel window. The DSN with the Microsoft Text Driver should now be setup. The connection can be tested with applications such as Microsoft Access or Query.



This article was TechKnowledge Document ID: 18432

Properties

Article ID: 850320 - Last Review: October 15, 2011 - Revision: 3.0
Keywords: 
kbmbsmigrate kbretire KB850320
Retired KB Content Disclaimer
This article was written about products for which Microsoft no longer offers support. Therefore, this article is offered "as is" and will no longer be updated.

Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from smallbusiness.support.microsoft.com