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. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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
|
|||
|
|||
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 | |
|
|