Parameter Query to txt File

[EllenM]

Hello,
A former coworker of mine wrote a parameter query for us. This coworker
then generated a tab delimited txt file from the desired dynaset and I don't
remember how. It also looks like quotes (") were some kind of a delimiter.
All the data and headers were encased in quotes.

Can someone figure out how this txt file was prepared?

Thanks in advance,
Ellen

 

[Michel Walsh]

A possibility is through the Export menu item (under File).


Vanderghast, Access MVP

 

[EllenM]

Thanks, Michael. I tried that and got an error message stating: "Too few
parameters. Expected 2"

Here's the query:
SELECT tbl_Delete_Dump.Foi_Request, tbl_Delete_Dump.PDF_File,
tbl_Delete_Dump.Pagination_Range, tbl_Delete_Dump.Author,
tbl_Delete_Dump.Title, tbl_Delete_Dump.Date_Publish,
tbl_Delete_Dump.Publisher, tbl_Delete_Dump.BIB_Info
FROM tbl_Delete_Dump
WHERE (((tbl_Delete_Dump.del_ID) Between [From ID] And [To ID]));

 

[Michel Walsh]

If you have a parameter, the easiest way is probably to use a macro: start a
new macro.

The Action to choose is TransferText

Transfer Type: Export Delimited
Table Name : The name of your saved query
File Name : The file name that will get the data


save and run the macro just created. In your case, you will be prompted for
From ID and To ID



Vanderghast, Access MVP

 

[EllenM]

Thanks so much, Michel. It works perfectly!!