I was wondering if there is a way to take a .csv file and import it and then
export as a .prn file specific format. Let me try to give an example. We
want to take a file that we are exporting from our payroll software into
Access and save it as a.csv file. From there we want Excel to import this
file using a template format that will then export this as a .prn file. The
..prn file will need to be formated so that record is a file 145 characters in
length and various sections represent specific file data. Such as position
1-12 = account number, position 12-20 = Payee First Name, etc...

Can Excel pull in one format, automatically convert to a fixed width field
that can then be exported? I know how to create the prn file manually but
want to know if a template can be created that will autoformat when the data
is pulled in?

Sorry for the long winded description...

Rick