Thanks you for repying, I was expecting a reply such as this and I am not prpared fully, here goes.
I assumed that the ease with which data can be pulled using Myodbc from MySQL and chnaged within excel could simple be used to 'UPDATE' the selected recordset. Clearly this is not the case. I am working with oscommerce and as many people have no doubted fund the frustrating aspect of updating and adding many records (records that already exist in another DB excel for instance) So, I want to pull the records from my orginal source (its a SQL server but the application is bespoke) inot excel and then use a similar conncetion as odbc to update MySQL? Is this impossible? I am going to guess that it is and that I am going to have to create a bespoke manual 'UPDATE' query for the product tables ... alas there are more tables with joins so this is where the fun will begin. If I have this completely incorrect please do let me know, as I was thinking of something else called data transfer method Andrew >-----Original Message----- >From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] >Sent: 14 June 2004 20:56 >To: [EMAIL PROTECTED] >Cc: MySQL-Lista >Subject: Re: odbc reverse > > > >I don't have enough information to answer your question. What platform are >you on? What language/DB library are you using to call the ODBC driver? The >answers you seek may be in the documentation for the particular >language-library combination you are using. > >Eventually it all boils down to 3 different SQL commands: SELECT, INSERT, >and UPDATE. > >Please give us more details so that we can understand what you are trying >to do. > >Yours, >Shawn Green >Database Administrator >Unimin Corporation - Spruce Pine > > > > > > "Business A2Z" > > <[EMAIL PROTECTED] To: "MySQL-Lista" ><[EMAIL PROTECTED]> > r.co.uk> cc: > > Fax to: > > 06/14/2004 03:45 Subject: odbc reverse > > PM > > Please respond to > > info > > > > > > > > > >Hi All > >I have a puzzle or more like a mental block that needs some sensible >thought >inputs please. > >If I odbc inot mysql and pull out records and make chnages how do I put the >changes back into mysql ? > >Hope there is a simple response to this > >Andrew > > >-- >MySQL General Mailing List >For list archives: http://lists.mysql.com/mysql >To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > > > > > > > >--- >Incoming mail is certified Virus Free. >Checked by AVG anti-virus system (http://www.grisoft.com). >Version: 6.0.701 / Virus Database: 458 - Release Date: 07/06/2004 > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
