need help dumping data to easily import into MS Access

Collapse
This topic is closed.
X
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • NotGiven
    #1

    need help dumping data to easily import into MS Access

    I have a db that I need to dump into a format that can be easily read my MS
    Access. I tried the dump with regular PHPAdmin. Then I used the dump to
    run a query in MS Access.

    Errors occurred because MySQL inserts a backslash, "\", in front of an
    apostophe that user enters in a text field and MS Access doesn't know how to
    interpret that.

    Any ideas for easily getting whatever kind of data from MySQL to MS Access?

    Many thanks in advance!


    Tags: None
    • Toshi1873
      #2
      Re: need help dumping data to easily import into MS Access

      In article <5MThb.919$JE4. 207@bignews4.be llsouth.net>,
      noname@nonegive n.net says...[color=blue]
      > I have a db that I need to dump into a format that can be easily read my MS
      > Access. I tried the dump with regular PHPAdmin. Then I used the dump to
      > run a query in MS Access.
      >
      > Errors occurred because MySQL inserts a backslash, "\", in front of an
      > apostophe that user enters in a text field and MS Access doesn't know how to
      > interpret that.
      >
      > Any ideas for easily getting whatever kind of data from MySQL to MS Access?
      >
      > Many thanks in advance!
      >
      >
      >[/color]

      Have you tried installing the ODBC connector?
      (http://www.mysql.com/products/myodbc/index.html)

      That lets you connect to the MySQL database and link to the tables on
      the MySQL server. You can then just use append queries that read from
      the MySQL server table and dump the data into a local MSAccess table.

        Comment

        • Toshi1873
          #3
          Re: need help dumping data to easily import into MS Access

          In article <5MThb.919$JE4. 207@bignews4.be llsouth.net>,
          noname@nonegive n.net says...[color=blue]
          > I have a db that I need to dump into a format that can be easily read my MS
          > Access. I tried the dump with regular PHPAdmin. Then I used the dump to
          > run a query in MS Access.
          >
          > Errors occurred because MySQL inserts a backslash, "\", in front of an
          > apostophe that user enters in a text field and MS Access doesn't know how to
          > interpret that.
          >
          > Any ideas for easily getting whatever kind of data from MySQL to MS Access?
          >
          > Many thanks in advance!
          >
          >
          >[/color]

          Have you tried installing the ODBC connector?
          (http://www.mysql.com/products/myodbc/index.html)

          That lets you connect to the MySQL database and link to the tables on
          the MySQL server. You can then just use append queries that read from
          the MySQL server table and dump the data into a local MSAccess table.

            Comment

            • NotGiven
              #4
              Re: need help dumping data to easily import into MS Access

              That would work except the server is a hosting company and I need to do this
              over encrypted lines so the data is never compromised.

              I was hoping to dump the MySQL data then rebuild it in Access - doesn't
              work.

              There's a INTO OUTFILE command that looks interesting in MySQL I'll check
              out.


              "Toshi1873" <toshio1873@now here.com> wrote in message
              news:MPG.19f29c 9a9c25a55298968 6@news-50.giganews.com ...[color=blue]
              > In article <5MThb.919$JE4. 207@bignews4.be llsouth.net>,
              > noname@nonegive n.net says...[color=green]
              > > I have a db that I need to dump into a format that can be easily read my[/color][/color]
              MS[color=blue][color=green]
              > > Access. I tried the dump with regular PHPAdmin. Then I used the dump[/color][/color]
              to[color=blue][color=green]
              > > run a query in MS Access.
              > >
              > > Errors occurred because MySQL inserts a backslash, "\", in front of an
              > > apostophe that user enters in a text field and MS Access doesn't know[/color][/color]
              how to[color=blue][color=green]
              > > interpret that.
              > >
              > > Any ideas for easily getting whatever kind of data from MySQL to MS[/color][/color]
              Access?[color=blue][color=green]
              > >
              > > Many thanks in advance!
              > >
              > >
              > >[/color]
              >
              > Have you tried installing the ODBC connector?
              > (http://www.mysql.com/products/myodbc/index.html)
              >
              > That lets you connect to the MySQL database and link to the tables on
              > the MySQL server. You can then just use append queries that read from
              > the MySQL server table and dump the data into a local MSAccess table.[/color]


                Comment

                • NotGiven
                  #5
                  Re: need help dumping data to easily import into MS Access

                  That would work except the server is a hosting company and I need to do this
                  over encrypted lines so the data is never compromised.

                  I was hoping to dump the MySQL data then rebuild it in Access - doesn't
                  work.

                  There's a INTO OUTFILE command that looks interesting in MySQL I'll check
                  out.


                  "Toshi1873" <toshio1873@now here.com> wrote in message
                  news:MPG.19f29c 9a9c25a55298968 6@news-50.giganews.com ...[color=blue]
                  > In article <5MThb.919$JE4. 207@bignews4.be llsouth.net>,
                  > noname@nonegive n.net says...[color=green]
                  > > I have a db that I need to dump into a format that can be easily read my[/color][/color]
                  MS[color=blue][color=green]
                  > > Access. I tried the dump with regular PHPAdmin. Then I used the dump[/color][/color]
                  to[color=blue][color=green]
                  > > run a query in MS Access.
                  > >
                  > > Errors occurred because MySQL inserts a backslash, "\", in front of an
                  > > apostophe that user enters in a text field and MS Access doesn't know[/color][/color]
                  how to[color=blue][color=green]
                  > > interpret that.
                  > >
                  > > Any ideas for easily getting whatever kind of data from MySQL to MS[/color][/color]
                  Access?[color=blue][color=green]
                  > >
                  > > Many thanks in advance!
                  > >
                  > >
                  > >[/color]
                  >
                  > Have you tried installing the ODBC connector?
                  > (http://www.mysql.com/products/myodbc/index.html)
                  >
                  > That lets you connect to the MySQL database and link to the tables on
                  > the MySQL server. You can then just use append queries that read from
                  > the MySQL server table and dump the data into a local MSAccess table.[/color]


                    Comment

                    • s a n j a y
                      #6
                      Re: need help dumping data to easily import into MS Access

                      probably mysqldump is what you are looking for. It can dump all the
                      databases with all the tables or just the table your select. You can dump
                      the data to a text file or onto the screen

                      hope this helps

                      sanjay


                      "NotGiven" <noname@nonegiv en.net> wrote in message
                      news:5MThb.919$ JE4.207@bignews 4.bellsouth.net ...
                      | I have a db that I need to dump into a format that can be easily read my
                      MS
                      | Access. I tried the dump with regular PHPAdmin. Then I used the dump to
                      | run a query in MS Access.
                      |
                      | Errors occurred because MySQL inserts a backslash, "\", in front of an
                      | apostophe that user enters in a text field and MS Access doesn't know how
                      to
                      | interpret that.
                      |
                      | Any ideas for easily getting whatever kind of data from MySQL to MS
                      Access?
                      |
                      | Many thanks in advance!
                      |
                      |


                        Comment

                        • s a n j a y
                          #7
                          Re: need help dumping data to easily import into MS Access

                          probably mysqldump is what you are looking for. It can dump all the
                          databases with all the tables or just the table your select. You can dump
                          the data to a text file or onto the screen

                          hope this helps

                          sanjay


                          "NotGiven" <noname@nonegiv en.net> wrote in message
                          news:5MThb.919$ JE4.207@bignews 4.bellsouth.net ...
                          | I have a db that I need to dump into a format that can be easily read my
                          MS
                          | Access. I tried the dump with regular PHPAdmin. Then I used the dump to
                          | run a query in MS Access.
                          |
                          | Errors occurred because MySQL inserts a backslash, "\", in front of an
                          | apostophe that user enters in a text field and MS Access doesn't know how
                          to
                          | interpret that.
                          |
                          | Any ideas for easily getting whatever kind of data from MySQL to MS
                          Access?
                          |
                          | Many thanks in advance!
                          |
                          |


                            Comment

                            Previous template Next
                            Working...