List:MySQL ODBC« Previous MessageNext Message »
From:Dan Date:July 17 1999 3:47pm
Subject:RE: Access 2000 vs. Access'97 with MyODBC
View as plain text  
At 13:18 18/07/1999 -0400, Jakub Linowski wrote:
>At 01:41 PM 15/07/99 , you wrote:
>This is how I loaded a Mysql table with data from ms access:
>
>I have Table A : Data in ms access
>I goto MySQL and create a Table B manually (CREATE TABLE ....) from the shell
>Then I LINK that empty Table B into MS access
>Then I create a query in DESIGN view...
>Show / select Table A (with the data)
>From top tabs select "Query -_> Append Query"
>select Table A (empty one / LINKED from MySQL)
>then you have to select all the fields that you want to APPEND (from that
>popup window below)
>
Well, it helps, but the very reasons that pushed me towards using MyOdbc is
that I do not want to go through the burden of writing plenty of lines to
create a table with data native from Access.Of course indexing and fine
tuning has always been another matter....
Under the dominion of Access 97 MyOdbc made it easy, which is -now with no
doubt left- no longer true under Access 2000.
Frankly I'm convinced that something has been changed by MS either in
Acc2000 or in ODBC 4, nonetheless I'm sure that any hassle could be removed
by a MyOdbc re-design.

regards
Daniele Berti

>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
Official Cookie Pal Beta tester >
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
EMail address : daberti@stripped
ECDL (European Computer Driving License) Rif. DS0008 
PGP 2.63i Key ID: ECC14A51 
Key Fingerprint = 4C C0 DB BD 85 D8 E7 D3  C4 63 82 53 DC 7E 82 EC
DSS key available
ICQ# 22091823
Thread
Access 2000 vs. Access'97 with MyODBCDaniel D. Reid15 Jul
  • Re: Access 2000 vs. Access'97 with MyODBCColin McKinnon15 Jul
    • RE: Access 2000 vs. Access'97 with MyODBCStephen Dahl15 Jul
      • RE: Access 2000 vs. Access'97 with MyODBCDan15 Jul
        • RE: Access 2000 vs. Access'97 with MyODBCJakub Linowski15 Jul
          • RE: Access 2000 vs. Access'97 with MyODBCDan17 Jul
    • RE: Access 2000 vs. Access'97 with MyODBCDaniel D. Reid15 Jul
      • RE: Access 2000 vs. Access'97 with MyODBCJakub Linowski15 Jul
  • Access 2000 vs. Access'97 with MyODBCMichael Widenius30 Jul
    • RE: Access 2000 vs. Access'97 with MyODBCDaniel D. Reid31 Jul
RE: Access 2000 vs. Access'97 with MyODBCDaniel D. Reid15 Jul
  • Re: Access 2000 vs. Access'97 with MyODBCPatrick Sherrill15 Jul
    • RE: Access 2000 vs. Access'97 with MyODBCDaniel D. Reid15 Jul
      • RE: Access 2000 vs. Access'97 with MyODBCPaul DuBois17 Jul