Export Specifications?

[Bonnie]

Using A02 on XP. Trying to export data to a comma
delimited text file. Using macro, trying OutPut To and
Transfer Text. I need to set export specs. HOW??? The
instructions below DO NOT give me the ability to set any
export specs. I can't seem to find it anywhere. It's hard
to find the Import specs but at least it's there
somewhere. Problem here is the default is tab delimited
and I need comma delimited and need to name the file with
a funky extension for the system to accept. Right now I
have my data in a query. Must I use a report for this
export? It didn't seem to matter and I just need the
export, I don't need to see anything on screen. Any help
or advice on this would be greatly appreciated!!! Thanks
in advance. Below is part of the help text and it speaks
with a forked tongue!!!

Access 2002 Help reads:
"You can use the Import or Link Tables subcommand of the
Get External Data command or the Export command on the
File menu to create a specification for a particular type
of text file; for example, a delimited text file that uses
tabs to separate fields and has an MDY format for dates.
When you click one of these commands and select a type of
text file to import, export, or link, the Import Text
Wizard, Export Text Wizard, or Link Text Wizard runs. You
can click the Advanced button in the wizard and define and
save a specification in the dialog box that appears. You
can then type the specification name in this argument
whenever you want to import or export the same type of
text file.

You can import, export, or link delimited text files
without typing a specification name for this argument. In
this case, Access uses the defaults from the wizard dialog
box."

 

[Steve Schapel]

Bonnie,

To be honest, I can't see the "forked tongue" aspect of the quoted Help
information. It is the correct advice for your problem. I will attempt
to re-phrase and clarify the bits that are relevant to your immediate needs.

From the design view of the query whose data you want to export, select
Export from the File menu. Follow the steps of the Export Wizard. When
you get to the last screen of the wizard, click the 'Advanced' button,
which will pop up the Export Specification window. Click the 'Save as'
button and give the Specification a name. Complete the wizard process.

OK, now when you make your TransferText macro, you can enter the name of
this specification in the macro argument.

I do not think it is correct that the default is Tab delimited, it is
normally a comma by default. However, as regards the funky filename
extension, I am not 100% sure but I think you are out of luck. I
believe the only acceptable extensions are .txt, .csv, .tab, and .asc.
Of these, .csv is probably the most applicable. If you need it to be
something else, I think you will have to export it to one of the
supported options, and then rename afterwards.

 

[Bonnie]

Thank you Steve, VERY much for the info. My error was that
as soon as I went to File, Export and the Save As and name
it here stuff, I could not see the 'Advanced' button. I
admit my heart was weak and I trod no further. The button
was on the Export Wizard. And yes, to be honest, sometimes
when I ask about a Help issue here, one of you guys IS
able to break it down differently and I can then
understand. Again, thanks and sorry to have tried your
patience but I really did learn something here. I've used
Import but never Export.

-----Original Message-----
Bonnie,

To be honest, I can't see the "forked tongue" aspect of the quoted Help
information. It is the correct advice for your problem. I will attempt
to re-phrase and clarify the bits that are relevant to your immediate needs.

From the design view of the query whose data you want to export, select
Export from the File menu. Follow the steps of the Export Wizard. When
you get to the last screen of the wizard, click the 'Advanced' button,
which will pop up the Export Specification window. Click the 'Save as'
button and give the Specification a name. Complete the wizard process.

OK, now when you make your TransferText macro, you can enter the name of
this specification in the macro argument.

I do not think it is correct that the default is Tab delimited, it is
normally a comma by default. However, as regards the funky filename
extension, I am not 100% sure but I think you are out of luck. I
believe the only acceptable extensions

are .txt, .csv, .tab, and .asc.