Output file

  • Thread starter Thread starter Anne125
  • Start date Start date
A

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
 
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
 
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.
 
Back
Top