Home |
Search |
Today's Posts |
#1
|
|||
|
|||
arranging import text
Hi, I'm trying to import a .txt file and I'm using the import wizard. I
clicked the fixed width option. On the next step you set the column breaks and I'm confused on how to set breaks. For example, on the first line it has last name, first name, address, but the city and state are on the second line. how can I get each contact information on one row? Mindy |
#2
|
|||
|
|||
The text import wizard assumes that each record is on one line of
the text files; it doesn't support multiple line records. You'll have to write an import procedure yourself. -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "Mindy" wrote in message ... Hi, I'm trying to import a .txt file and I'm using the import wizard. I clicked the fixed width option. On the next step you set the column breaks and I'm confused on how to set breaks. For example, on the first line it has last name, first name, address, but the city and state are on the second line. how can I get each contact information on one row? Mindy |
#3
|
|||
|
|||
can you write the steps down on how to write an import procedure?
"Chip Pearson" wrote: The text import wizard assumes that each record is on one line of the text files; it doesn't support multiple line records. You'll have to write an import procedure yourself. -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "Mindy" wrote in message ... Hi, I'm trying to import a .txt file and I'm using the import wizard. I clicked the fixed width option. On the next step you set the column breaks and I'm confused on how to set breaks. For example, on the first line it has last name, first name, address, but the city and state are on the second line. how can I get each contact information on one row? Mindy |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Text import wizard defaults? | Excel Discussion (Misc queries) | |||
Import comma delimited text | Excel Discussion (Misc queries) | |||
how do I enable "import text file" excel 2002? | Excel Discussion (Misc queries) | |||
Text import out of line? | Excel Discussion (Misc queries) | |||
VBA Import of text file & Array parsing of that data | Excel Discussion (Misc queries) |