Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Data Entry Online, Data Format, Data Conversion and Data EntryServices through Data Entry Outsourcing | Excel Discussion (Misc queries) | |||
Performing Data Transformations | Excel Programming | |||
excel graph transformations | Excel Programming | |||
excel graph transformations | Excel Programming | |||
excel graph transformations | Excel Programming |