Can someone please provide a step by step on how to do the following:
I have an Excel spreadsheet with cell An containing words I'd like replaced with the corresponding value in cell Bn.
I need to apply the changes above to a column in a DB Table (i.e. update an entire column in a DB table, making changes represented in the spreadsheet).
Thanks a 10^9.
DB Conn
Moderators: DataMystic Support, Moderators, DataMystic Support, Moderators, DataMystic Support, Moderators
-
DataMystic Support
- Site Admin
- Posts: 2227
- Joined: Mon Jun 30, 2003 12:32 pm
- Location: Melbourne, Australia
- Contact:
Ok. Let me know if you need more details.
1. Using TextPipe, import your Excel spreadsheet as a search/replace list. Save this filter.
2. Using DataPipe (which you may have to download from our website), find the table you need to change, and then use the filter from #1 to apply to the column.
3. When DataPipe is run, the replacements will be performed.
1. Using TextPipe, import your Excel spreadsheet as a search/replace list. Save this filter.
2. Using DataPipe (which you may have to download from our website), find the table you need to change, and then use the filter from #1 to apply to the column.
3. When DataPipe is run, the replacements will be performed.