Loading MySQL from Access

Collapse
This topic is closed.
X
X
 
  • Time
  • Show
Clear All
new posts
  • Bruce A. Julseth

    Loading MySQL from Access

    I can export from Access and Load Data InFile into MySQL but was wondering
    if there is a direct way of loading MySQL from Access?

    Thank you.


  • daemon

    #2
    Re: Loading MySQL from Access

    Bruce A. Julseth wrote:[color=blue]
    > I can export from Access and Load Data InFile into MySQL but was wondering
    > if there is a direct way of loading MySQL from Access?
    >
    > Thank you.
    >
    >[/color]
    Ya, there is always another way, just by simply using Access DB
    functions from PHP and then modifying the responces of your DB to work
    with the MySQL functions in PHP.

    Otherwise, re-create the wheel by using sockets!

    Comment

    • Bruce A. Julseth

      #3
      Re: Loading MySQL from Access


      "daemon" <d43m0n@shaw.ca > wrote in message
      news:eRQHe.9705 7$5V4.75007@pd7 tw3no...[color=blue]
      > Bruce A. Julseth wrote:[color=green]
      >> I can export from Access and Load Data InFile into MySQL but was
      >> wondering if there is a direct way of loading MySQL from Access?
      >>
      >> Thank you.[/color]
      > Ya, there is always another way, just by simply using Access DB functions
      > from PHP and then modifying the responces of your DB to work with the
      > MySQL functions in PHP.
      >
      > Otherwise, re-create the wheel by using sockets!
      >[/color]

      Super! Can you point me to some examples of using Access DB functions from
      PHP? I'm sort of a newbie at this stuff.

      Thanks..


      Comment

      • Alvaro G Vicario

        #4
        Re: Loading MySQL from Access

        *** Bruce A. Julseth wrote/escribió (Tue, 2 Aug 2005 13:17:42 -0400):[color=blue]
        > I can export from Access and Load Data InFile into MySQL but was wondering
        > if there is a direct way of loading MySQL from Access?[/color]

        Install the ODBC driver for MySQL and link tables in your Access document.



        --
        -- Álvaro G. Vicario - Burgos, Spain
        -- http://bits.demogracia.com - Mi sitio sobre programación web
        -- Don't e-mail me your questions, post them to the group
        --

        Comment

        Working...