Output file

[Anne125]

I have data in an Access (2007) db that I need to export into an unusual
format. (Format: Record length is 6694 characters, there are no delimiters,
data is located at specific places along the length- i.e., first name is
located at 1972 and is 14 characters in length.) Is there a way I can build
my own export format in Access, so my data will not have to go through
another program (i.e., thru SAS) to be converted?
Thank you for the help

 

[Larry Daugherty]

Yes, use low lever I/o, called File I/O. It allows you complete
flexibility to place elements in a file however you choose. In effect
your file will be a single line.

HTH

 

[AG]

It sounds like you mean fixed width format, where each field is a specific
width, regardless of it's content.
If so, External Data > Text File >
Make sure 'Export data with formatting and layout' is UNchecked.
Select 'Fixed width - ...' and follow the wizard or use the Advanced button.