ACC97: "Too few parameters. Expected 1" Error Message When You Export Parameter Query as Text (262837)

SYMPTOMS

When you export a parameter query as a text file, you may receive the following error message, where X is the number of parameters in the query:

Too few parameters. Expected X.

To work around this issue, create a SQL statement similar to the SQL statement created in the following steps:

Open the sample database Northwind.mdb.
In the Database window, click the Employees table, click Insert, and then click Query.
In the New Query dialog box, click OK.
On the View menu, click SQL View.
Type the following SQL statement:
SELECT * INTO [Text;FMT=Delimted;HDR=Yes;DATABASE=C:\;].[Employees#txt] FROM Employees WHERE [EmployeeID] = [Enter an EmployeeID];
Save the query as Query1.
On the Query menu, click Run. Note that a text file named "Employees.txt" was created on drive C, and that it contains only the data for the EmployeeID that you entered in the parameter box.

Open the sample database Northwind.mdb.
In the Database window, click the Employees table, click Insert, and then click Query.
In the New Query dialog box, click OK.
Double-click EmployeeID in the field list to add it to the query design grid.
In the Criteria row of the query design grid, under EmployeeID, type the following criteria:
[Enter an Employee ID]
Save this query as Query1.
On the Query menu, click Run. Type a valid EmployeeID and note that one record is returned.
On the File menu, click Save As/Export. Click To an External File or Database, and then click OK.
In the Files of type list, click Text Files, and then click Export. Note that you receive the error message mentioned in the "Symptoms" section of this article.