Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

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

19 views
Skip to first unread message

G @discussions.microsoft.com Bec G (Oz)

unread,
Nov 12, 2009, 1:40:09 AM11/12/09
to
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

unread,
Nov 12, 2009, 7:50:23 AM11/12/09
to

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

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


--
joel
------------------------------------------------------------------------
joel's Profile: http://www.thecodecage.com/forumz/member.php?userid=229
View this thread: http://www.thecodecage.com/forumz/showthread.php?t=153349

[url="http://www.thecodecage.com"]Microsoft Office Help[/url]

JLatham

unread,
Nov 12, 2009, 8:11:01 AM11/12/09
to
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.

0 new messages