Thank you agsain not sure if I am following this correctly but will go and
search for some reading thank you once again... is this the right thisng you
refer to?
OLE DB Provider for mySQL
oConn.Open "Provider=MySQLProv;" & _
"Data Source=mySQLDB;" & _
"User Id=myUsername;" & _
"Password=myPassword"
For more information, see: API - OLE DB and Snippet
I didn't think it was going to be a MS solutionnto update mysql :(
Andrew
>-----Original Message-----
>From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
>Sent: 14 June 2004 21:52
>To: [EMAIL PROTECTED]
>Cc: [EMAIL PROTECTED]; MySQL-Lista
>Subject: RE: odbc reverse
>
>
>
>It seems to me that you are trying to use EXCEL as some type of live data
>entry form. That would require "binding" an excel sheet to your data
>source (through ADO through ODBC to the MySQL server). There are many
>examples of this type of binding. You didn't say, but I assume that your
>EXCEL is running on a windows platform.
>
>May I politely refer you to the Microsoft Developers Network site. I am
>sure you will find some specific examples of binding Excel to various
>databases. It should be the matter of a change or two to modify one of
>their examples so that you are using MySQL and not MSSQL or Access as your
>data source. You may have to search on several different terms, though.
>That site has a **LOT** of information but it's not always where you
>logically think it should be.
>
>http://msdn.microsoft.com/
>
>Sorry I can't be more helpful but I haven't used EXCEL+ADO+ODBC to bind to
>a live dataset in a VERY long time and I am sure to say the wrong thing.
>
>Shawn
>
>
>
>
>
> "Business A2Z"
>
> <[EMAIL PROTECTED] To:
><[EMAIL PROTECTED]>, <[EMAIL PROTECTED]>
> r.co.uk> cc: "MySQL-Lista"
><[EMAIL PROTECTED]>
> Fax to:
>
> 06/14/2004 04:30 Subject: RE: odbc
>reverse
> PM
>
> Please respond to
>
> info
>
>
>
>
>
>
>
>
>
>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
>>
>
>
>
>
>
>
>
>---
>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]
