You receive a "Syntax error in FROM clause" error message when you use the AppWizard to create a CRecordset class by using the ODBC Text Driver in Visual C++

MORE INFORMATION

Steps to Reproduce Behavior

In Notepad

1. Create a text file with the following content:

         Field1,Field2
         1,abc
   						

2. Save this file as Table.txt and close it.
3. Create a new User DSN based on the Microsoft Text Driver and name it TextDriverSample.
4. Clear the Use Current Directory box.
5. Click the Select Directory button and select the directory that contains Table.txt.
6. Click Options.
7. Select *.txt from the Extensions list box.
8. Click the Define Format button.
9. Select Table.txt.
10. Select the Column Name Header box.
11. From the Format combo box, select CSV Delimited.
12. Click the Guess button.
13. Save and exit the ODBC Manager.

Start Visual C++ 5.0 or Visual C++ 6.0

1. Create a new MFC application.
2. Select Single Document, then click Next.
3. Select Database View Without File Support.
4. Click the Data Source button.
5. From the ODBC combo box, select TextDriverSample, then click OK.
6. From the Database Tables list, select Table.txt.
7. Click OK, then click Finish.
8. Compile the project.