RE: Urgent: Sql 6.5 Guru Question

from a few other people as well, it was easier to implement than I thought. Thanks, Ryan -Original Message- From: Ryan Hill Sent: Monday, August 07, 2000 1:53 PM To: '[EMAIL PROTECTED]' Subject: Urgent: Sql 6.5 Guru Question Hello everyone, Got a problem here that I can't seem

Urgent: Sql 6.5 Guru Question

Hello everyone, Got a problem here that I can't seem to figure out. I have a tab-delimited text file containing 3 cols, (can_id, votes, % votes) that I need to import into a SQL 6.5 table containing these three columns (and others) that needs to be updated on a regular basis - updating existing

Re: Urgent: Sql 6.5 Guru Question

I am not a guru - but may have a work-around until someone gives you the best answer:) Set up the text file as an odbc text datasource, and let CF read it in one at a time, then update the sql database. OR bcp it into a temporary table, then use that table to do the update of the live