Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
importing two text files to same sheet
I know there are a few similar posts out there but I want a little more
specific information. I am going to be getting two text files from two different databases. All information is coded to specific jobID numbers. I want to be able to import one file and then the other. The part that may be tricky is I want to match the second import information to the JobID from the first import. I hope this makes sense. -- Greg |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
importing two text files to same sheet
If you are not sure the rows will all line up appropriately, you should
import the two text files to two different XL sheets and then construct a VLOOKUP formula to conjoin the data.......... hth Vaya con Dios, Chuck, CABGx3 "Greg" wrote: I know there are a few similar posts out there but I want a little more specific information. I am going to be getting two text files from two different databases. All information is coded to specific jobID numbers. I want to be able to import one file and then the other. The part that may be tricky is I want to match the second import information to the JobID from the first import. I hope this makes sense. -- Greg |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
importing two text files to same sheet
I am familiar with how vlookups work but I'm not sure I follow. The difficult
part of this is that one import may have more than one instance of the same JobID (flattening of parent to child relationship) but the second import will only be solely unique. -- Greg "CLR" wrote: If you are not sure the rows will all line up appropriately, you should import the two text files to two different XL sheets and then construct a VLOOKUP formula to conjoin the data.......... hth Vaya con Dios, Chuck, CABGx3 "Greg" wrote: I know there are a few similar posts out there but I want a little more specific information. I am going to be getting two text files from two different databases. All information is coded to specific jobID numbers. I want to be able to import one file and then the other. The part that may be tricky is I want to match the second import information to the JobID from the first import. I hope this makes sense. -- Greg |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
importing two text files to same sheet
I figured out what you suggested with the vlookup. That'll work. I think my
brain left at lunch time. Thanks again -- Greg "Greg" wrote: I am familiar with how vlookups work but I'm not sure I follow. The difficult part of this is that one import may have more than one instance of the same JobID (flattening of parent to child relationship) but the second import will only be solely unique. -- Greg "CLR" wrote: If you are not sure the rows will all line up appropriately, you should import the two text files to two different XL sheets and then construct a VLOOKUP formula to conjoin the data.......... hth Vaya con Dios, Chuck, CABGx3 "Greg" wrote: I know there are a few similar posts out there but I want a little more specific information. I am going to be getting two text files from two different databases. All information is coded to specific jobID numbers. I want to be able to import one file and then the other. The part that may be tricky is I want to match the second import information to the JobID from the first import. I hope this makes sense. -- Greg |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
importing two text files to same sheet
Not a problem, and thanks for letting us know. Sorry it took so long to get
back to you but I been running errands and just got home. Glad to hear you got it sorted........it was a difficult thing to try and explain in just text..........Post back if you have any more problems with it.......... Vaya con Dios, Chuck, CABGx3 "Greg" wrote in message ... I figured out what you suggested with the vlookup. That'll work. I think my brain left at lunch time. Thanks again -- Greg "Greg" wrote: I am familiar with how vlookups work but I'm not sure I follow. The difficult part of this is that one import may have more than one instance of the same JobID (flattening of parent to child relationship) but the second import will only be solely unique. -- Greg "CLR" wrote: If you are not sure the rows will all line up appropriately, you should import the two text files to two different XL sheets and then construct a VLOOKUP formula to conjoin the data.......... hth Vaya con Dios, Chuck, CABGx3 "Greg" wrote: I know there are a few similar posts out there but I want a little more specific information. I am going to be getting two text files from two different databases. All information is coded to specific jobID numbers. I want to be able to import one file and then the other. The part that may be tricky is I want to match the second import information to the JobID from the first import. I hope this makes sense. -- Greg |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Retain Numbers as Text Format When Importing. | Excel Discussion (Misc queries) | |||
importing multiple text files into the same worksheet | Excel Discussion (Misc queries) | |||
Select Text Files from Combobox | Excel Discussion (Misc queries) | |||
Chart Title or Text Box Linked to cell & sheet | Charts and Charting in Excel | |||
Find all text instances in a sheet and add one number from each row | Excel Discussion (Misc queries) |