DB Conn

Get help with installation and running here.

Moderators: DataMystic Support, Moderators

mowgli_za

DB Conn

Postby mowgli_za » Wed Nov 19, 2003 11:08 pm

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.

User avatar
DataMystic Support
Site Admin
Posts: 2154
Joined: Mon Jun 30, 2003 12:32 pm
Location: Melbourne, Australia
Contact:

Postby DataMystic Support » Fri Nov 21, 2003 9:02 am

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.
Regards,

Simon Carter, http://DataMystic.com/forums/index.php
http://PredictBGL.com - Insulin dose calculator for Type 1 diabetes
http://DownloadPipe.com - 250,000 free software downloads
http://DetachPipe.com - send huge email attachments


Return to “TextPipe Tips and Tricks, Questions and Support”

Who is online

Users browsing this forum: Baidu [Spider] and 4 guests