Re: How do you make a fixed length (85 characters) format report o

From: Doug Kanter (ancientangler_at_hotmail.com)
Date: 08/06/04 

Date: Fri, 06 Aug 2004 20:27:05 GMT

I didn't try to do that. Not sure how. Usually, I'm on the receiving end of
such files from my customers. I open them in a text editor like NoteTab (not
Notepad), or WinEdit, note which fields begin in which columns, and set up
my database to extract accordingly.

But, you might experiment with columns widths.

"carter" <carter@discussions.microsoft.com> wrote in message
news:4D7911D5-E40C-4535-880C-D69051F4A650@microsoft.com...
> Thank you,
>
> How did you define the specific field lengths?
>
> "Doug Kanter" wrote:
>
> > When saving the file, choose the file type "Text (MS-DOS)(*.txt). It
just
> > worked fine for me.
> >
> > "carter" <carter@discussions.microsoft.com> wrote in message
> > news:4EC8F315-B579-486F-8D81-7E8416E3AF30@microsoft.com...
> > > I am trying to take data in an excel spread*** and create a fixed
length
> > > file for inport into another system. I have tried to merge it into a
> > word
> > > document, but I couldn't get fixed record lengths. Any help would be
> > > appreciated. If you can't do it in excel, do you know an application
that
> > I
> > > can transfer the data out of excel into, that can do it?
> >
> >
> >