Help with Update DB By Downloading File

shiba126
04-14-2004, 08:46 AM
Hi everyone,

I have an application which takes records from DB installed on their PC with the program. If I were to release any updates for the database, I have an option for the user to update their database. I would like them to download a new TABLE with the extra records in and have that merge into the current table.

E.g

I have table named LYRICS and I would like them to download another table say UPDATELYRICS[DATE] and automatically insert this table into the database, and then update the LYRICS table to include the UPDATELYRICS[DATE] and then delete the UPDATELYRICS[DATE] table.

I know it sounds like a tall order, but I would really appreciate any help possible. I'm stumped. I've tried putting an Internet Control in and focusing it towards an ASP page which requests the number of records, but then I can't figure out how to get the extra records across to the table and DB.


HELP!!! Cheers, :huh:

Chris

EZ Archive Ads Plugin for vBulletin Copyright 2006 Computer Help Forum