I have a query that I need to export to a .txt file. The query uses three fields from a form to identify which records to export. When I try to export the query to the .txt file I get a "Too few parameters. Expected 3". I know this is a result of the information from the form, when I hard code the information in place of the form text box reference, the query exports just fine.
Defining the parameters in the query does not solve the problem. I checked the Microsoft home page and the solution that they provide has two problems. First when the query is saved and reopened it changes the SQL so it makes a new table in the database rather then a new file. Second it always saves it as a comma delemimeted file. I need it saved as a tab delimited file.
Does anyone know how to solve this it has been drifing me nutts all day.
Brian
Defining the parameters in the query does not solve the problem. I checked the Microsoft home page and the solution that they provide has two problems. First when the query is saved and reopened it changes the SQL so it makes a new table in the database rather then a new file. Second it always saves it as a comma delemimeted file. I need it saved as a tab delimited file.
Does anyone know how to solve this it has been drifing me nutts all day.
Brian