Data Transformations
 

Hey all,

I am currently trying to solve an issue where I need to move data from
one source to another, but the first source stores data in strings and
the second uses a relational model and stores by ID. Both sets of data
are in .xml files and a database exists with the data needed to turn
the strings into IDs. I am unsure though how to go about recording a
set of macros to do the transformations for me. I pulled up the data
connection box and it looks like I can enter SQL in the area called
"Command Text". However, I am not sure how to tell it to select the ID
where the String is what I have in the spreadsheet box. Any help would
be greatly appreciated.

Thank You,
Derrek