How can I import a very large PDL from outlook into excel

[Bec G (Oz)]

Hi

I've got a PDL that has 2000 names on it and I need to update it. I have a
list of names in excel which is the latest informaion that I need to compare
with the names on the PDL. I know I can use a vlookup to do the comparison
but when I try and bring in the PDL as a text file I lose all most of the
info as I have more names than columns in excel.

Any ideas greatly appreciated as I don't want to have to manually work out
the new names.

Thanks

Bec

 

[joel]

I probably need to see a sample of the text file. Hopefully it is i
CSV format. A macro can be written to open the text file a put the dat
into the workbook in any format you would like. One method would be t
transpose the rows and columns. Putting the names in the rows instead o
the columns. I'm surprized that outlook didn't do that.

If you still have more columns then the data can be put onto multipl
worksheets or if you are using Excel 2007 the limit of 256 columns ha
been eliminated

 

[JLatham]

Contact me at (remove spaces)
Help From @ JlathamSite. com
and I'll try to help. I'd need to write a routine to read the PDL file
directly from disk and 'transpose' it onto a sheet in your Excel book, and
that means I need to see the format and content of the PDL to figure out how
to do it. Although if you can accurately describe the PDL's format &
content, I might be able to do it without seeing the file - but nothing works
as well as having real-world data to test with.

Need to know things like the "field separator" when it's read as a text file
and whether each row of the PDL is a field related to the content of the 1st
row:

Like if your PDL file is something like:
Ralph, Phyllis, Mark
101, 832, 121
A44,B19,C304
where you would want it to end up as
Ralph 101 A44
Phyllis 832 B19
Mark 121 C304

we could work up a file read and import routine pretty easily.