Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Text Import Wizard
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Text Import Wizard
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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Text Import Wizard
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Text Import Wizard | Excel Discussion (Misc queries) | |||
Text Import Wizard | Excel Discussion (Misc queries) | |||
Text import format question | Excel Discussion (Misc queries) | |||
Text Import wizard | Excel Discussion (Misc queries) | |||
Text Import Wizard | Excel Discussion (Misc queries) |