To be honest, there are probably hundreds of workable solutions to the
*very* generic problem of moving data from one database to another. Using
an ODBC driver (or drivers) would definitely be an option. One of the
simplest methods is to export your spreadsheet to a CSV file (comma
separated, string-quoted, one-row per line) then use the bulk import
facility built in to MySQL (LOAD DATA INFILE...).
It all depends on what you need as far as connectivity. Which solutions
meet your design requirement I cannot guess as you have told us very little
about your situation. I recommended you read up on the MS documentation of
OLE DB, ADO, ODBC, VBA, and the product Excel as some combination of those
will allow you to create and keep a "live" connection to your data. If you
do not need interactive database connectivity, try the bulk export/bulk
import method I described earlier.
Sorry I wasn't more help. :-( ,
Shawn Green
Database Administrator
Unimin Corporation - Spruce Pine
"Business A2Z"
<[EMAIL PROTECTED] To: <[EMAIL PROTECTED]>, <[EMAIL
PROTECTED]>
r.co.uk> cc: <[EMAIL PROTECTED]>,
"MySQL-Lista"
<[EMAIL PROTECTED]>
06/14/2004 05:58 Fax to:
PM Subject: RE: odbc reverse
Please respond to
info
Ok final question on this for today, is it possible to move data into MySQL
through odbc from excel or any other data source come to think of it?
>-----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
>>
>
>
>
>
>
>
>
>--
>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]
