How do I get Access to create an undelimited ASCII file?

[Guest]

I am creating an application that has a number of requirements. One of which
is stated "your application must produce an ASCII flat file (undelimited)".
I'm relatively confident that access can do this but I'm not sure how to ask
it to. Thank you for your help.

 

[Andi Mayer]

I am creating an application that has a number of requirements. One of which
is stated "your application must produce an ASCII flat file (undelimited)".
I'm relatively confident that access can do this but I'm not sure how to ask
it to. Thank you for your help.

look for: open, print, print Line, put in the help file

 

[Albert D. Kallal]

Yes, you can either export a table, or often even better is a query, as that
query will only have the fields you want from the table. And, using a query
means you can set the sort order, and even some restrictions on what records
will get exported.

To create a fixed length export, you an simply can highlight the table (or
query) and go file->export.

The wizard can produce non delimited, fixed length flat files (quite a slick
user interface comes up to let you set the length of each export field via a
slider).