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

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

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