Text Import Wizard

[Dan]

How can I limit the number of lines the Wizard imports? I.e. want to limit
the import to the first 53 lines of a file that has 300 lines.

Want to import the first "XX" set of lines in a Delimited format (since this
is the header), then the other lines with the Fixed Width format.

Thanks

[Franz Verga]

Dan wrote:
> How can I limit the number of lines the Wizard imports? I.e. want to
> limit the import to the first 53 lines of a file that has 300 lines.
>
> Want to import the first "XX" set of lines in a Delimited format
> (since this is the header), then the other lines with the Fixed Width
> format.
>
> Thanks


Hi Dan,

You can first import your .txt in Delimited format, then delete the rows
from XX+1 and then import the file again from XX+1 in Fixed Width format.
You can also record some macro to automatize the process, if you need...


--
Hope I helped you.

Thanks in advance for your feedback.

Ciao

Franz Verga from Italy

[Dan]

Unfortnately the Import Wizard will not let you do this. If the file is
opened the first time you can not open it a second time without loosing the
information from the fist time.

"Franz Verga" wrote:

> Dan wrote:
> > How can I limit the number of lines the Wizard imports? I.e. want to
> > limit the import to the first 53 lines of a file that has 300 lines.
> >
> > Want to import the first "XX" set of lines in a Delimited format
> > (since this is the header), then the other lines with the Fixed Width
> > format.
> >
> > Thanks
>
>
> Hi Dan,
>
> You can first import your .txt in Delimited format, then delete the rows
> from XX+1 and then import the file again from XX+1 in Fixed Width format.
> You can also record some macro to automatize the process, if you need...
>
>
> --
> Hope I helped you.
>
> Thanks in advance for your feedback.
>
> Ciao
>
> Franz Verga from Italy
>
>
>