Export it as Delimited and in the next screen choose Comma. You may need to
change the file name from txt to csv.

Hi Amy,

CSV is included in "Text Files" in the "Save as type:" dropdown as you
start the export wizard. If the "Text Files" entry is missing from the
dropdown, see below:

If the import/export wizards don't work at all, or if you get "No object
in this control" re-register ACCWIZ.DLL.

If it's one or more file formats that aren't listed, re-register the
relevant files:
   msexcl40.dll    (Excel)
   msxbse40.dll     (dBase)
   mspdox40.dll    (Paradox)
   mstext40.dll     (Text, CSV, tab-delimited))
In Access 97, the filenames contain 35 instead of 40.

To re-register a DLL file,

1) Locate it (usually all these are in the Windows\System32 or
WINNT\System32 folder.)

2) Locate the file regsvr32.exe.

3) Drag the DLL file's icon onto the regsvr32.exe icon.

--
John Nurick [Microsoft Access MVP]

Please respond in the newgroup and not by email.