Cannot export Access 2003 parameterized query to a tab delimited .

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I using Access 2003 and have a parameterized query. When I right click on
the query, select Export, then choose to export to a Text Files
(*.txt,*.csv,...) Access asks me for a location. After I select the location
of the file and click the Export button, Access says that there are too few
parameters, followed by the number of missing parameters. This seems to be a
bug, since I remember doing this exact same thing under Office XP. In
addition, when Access asks me for a file location, if I check the Save
Formatted box it work, however that's not output format I really wanted. I
wanted to output in tab delimited format and you need to not check the Save
Formatted box. Has anyone else experienced this problem and figured a
workaround or is Access just broken without any hope of Microsoft fixing it.

Andy.
 
you can run the export from a form. create an unbound form (or use any form
you already have, bound or unbound). add a textbox for each parameter that
the query requires. add a command button; on the Click event, create either
a macro that uses the TransferText action (you can read up on it in Access
Help), or a VBA procedure that runs the DoCmd.TransferText action (you can
read up on it in Access VBA Help).

in the query, set each parameter criteria to pull the value from the
corresponding textbox on the form, as

Forms!FormName!TextboxControlName

substitute the correct form and control names, of course. to output the
data, open the form and enter the parameters in the controls, then click the
command button.

hth
 
Back
Top