Based on your structure, the memberid field is not autogenerated therefore not sure what issue you have by not doing a basic import? If your worried about duplications you can check that by importing all records into a temp table then run a query to grab the distinct records and import those.
If your new table has the memberid as autogenerated and has existing data, you need to determine if the data being imported matches any existing memberid records and if so, determine which takes precendence., You can still use a temp table to accomplish it. On Mon, Sep 22, 2008 at 8:54 PM, Toby King <[EMAIL PROTECTED]> wrote: > Hi there > > I have a MySQL database setup with a table called members. > > Basically the structure of the table is > > Memberid varchar 25 > Firstname varchar 40 > Lastname varchar 40 > > I have received the members list in an excel spreadsheet - approx 5,000 > names. > > Had the Memberid column been autogenerating then it would have been easy. > Just wanted to check how I do the the import - can I do an import to the > table and if so how do I put a value into the the memberid column. > > Thanks in advance > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:312930 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
