A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » General Discussion
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

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



 
 
Thread Tools Display Modes
  #1  
Old November 12th, 2009, 07:40 AM posted to microsoft.public.excel.misc
Bec G (Oz)[_2_]
external usenet poster
 
Posts: 1
Default How can I import a very large PDL from outlook into excel

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

  #2  
Old November 12th, 2009, 02:11 PM posted to microsoft.public.excel.misc
JLatham
external usenet poster
 
Posts: 1,896
Default How can I import a very large PDL from outlook into excel

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.


"Bec G (Oz)" wrote:

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

 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 01:36 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.