arranging import text

M

Mindy

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
 
C

Chip Pearson

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
 
Top