exporting fixed lenght or comma delimited?

[Dave]

I am using Access, I wish to export using fixed lenght
or comma delimited. These items are not listed as
options. Are these possible? How do I make these
options available?
Thanks

 

[Douglas J. Steele]

When you go to File | Export on the menu, one of the options should be Text
File (*.txt; *.csv; *.tab; *.asc). When you select that, a wizard will start
up that will let you define the export as fixed length or delimited. Follow
the instructions, and you should be able to get either of the formats you
mention.

 

[Joe Fallon]

And if thos options are not in your dropdown:

Try re-registering the dll files like this:
Start Run
regsvr32 msexcl35.dll
regsvr32 msxbse35.dll
regsvr32 mspdox35.dll
regsvr32 mstext35.dll

Use 40 instead of 35 for A2K and 2002.

That's MSEXCL35.dll not MSEXC1.dll.