![]() Choose Data, Import External Data, New Database Query, which displays the Choose Data Source dialog. The first step is to create a new connection - a “data source” - to add to the list in the Choose Data Source dialog below. Therefore, we need to work around the bug. Second, the MS Query Engine is based on Access version 1.0, and it has a bug that has never been corrected. With a text file, you will need to tell Excel how to interpret each field. ![]() This is more involved than the connection to an Excel workbook, for two reasons.įirst, an Excel workbook is capable of storing all of the information about the data that you’re connecting to. The first order of business is to create a connection to your text file database. For this example, they’re tab-delimited text files, but they could just as easily be comma-delimited or fixed length. This time, let’s look at the same three tables, only this time they’ll be stored as text files. In the article, Use MS Query to Treat Excel As a Relational Data Source, Marty Ryerson introduced a mini-database of three tables, and used Excel as the database container. (Charley’s Note: This article is very out of date.
0 Comments
Leave a Reply. |