Too few parameters. Expected 4. - Error occurs during export ot text but not to Excel

[canyonraven]

Hello there,

I have an export error that is leaving me stumped! I have a form with 4 controls that runs a parameter query. The query results appear to be correct. When I export the query to an Excel file, it works perfectly. When I try to export it to a text file, I get the error "Too few parameters. Expected 4". What's the difference. One suggestion I found online was to specify the parameters in the parameter box in the query design view. I tried that but I still get the error. If you need more information or the specific .accdb I can load it, but its a large file.

Thanks in advance,

canyonraven

[Welshgasman]

I do not know why it works when going to Excel and not to text, but try this method.

https://www.accessmvp.com/thedbguy/c...?title=generic

[June7]

I cannot replicate issue. Provide your code and sample data.

[canyonraven]

I am going to try attach a test db version of the database. It still generates the error above.

[Welshgasman]

The ONLY query able to run works for me from the button?

[davegri]

How are you exporting? This worked fine for me.

[CJ_London]

suggest take us through what you are supposed to do as I don't see any export button - only one that opens a query.

[Welshgasman]

How are you exporting? This worked fine for me.

I do get that error trying your method Dave.

@canyonraven
You have not even tried that function in the link I posted?

[davegri]

@canyonraven
You have not even tried that function in the link I posted?

There is not one single function in the db that you posted. There is no CODE to transfer to text or Excel. Have a look at what you posted.

[Welshgasman]

There is not one single function in the db that you posted. There is no CODE to transfer to text or Excel. Have a look at what you posted.

There is no DB in that link. Just a function that solves this issue.

The following functions were from fellow MVP, Leigh Purvis (LPurvis). It automatically evaluates any parameters in your SQL when using the OpenRecordset (DAO) or the Open (ADO) method to avoid getting Run-time error '3061': Too few parameters.

[Gicu]

You should change the query into a make-table query then export that new table.
Cheers,

[June7]

canyonraven, I had no problem exporting manually to .txt with the wizard. There is no code for export to any format.

[Welshgasman]

canyonraven, I had no problem exporting manually to .txt with the wizard. There is no code for export to any format.

Strange how I got the error?

[June7]

Okay, get the error if I do not check "Export data with formatting and layout".

I just tested VBA for TransferText to .csv and that works.

[canyonraven]

I was trying to export the data from the query using the External Data ribbon button export to text. That was the point when the "Too few parameters..." error came up. I also get this same error when I right click and select Export to Text as shown in davegri's and Welshgasman's posts (#6 and # 8) above.

Again, the really weird thing is that the error only comes up when exporting to text and not when exporting to Excel. It looks like the error is specific to the "Export Text Wizard". This is the error:




Is anyone able to reproduce this error using the methods above?