By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
459,504 Members | 1,194 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 459,504 IT Pros & Developers. It's quick & easy.

Access

P: n/a
Ken
How do I to move our data stored on an external server (over the Internet)
in a mySql database to
MS Access on our office computer. I would like to remove the data from the
Net and store it on our computer for security reasons.

Thanks.

Ken

Jul 17 '05 #1
Share this Question
Share on Google+
6 Replies


P: n/a
*** Ken wrote/escribió (Wed, 27 Apr 2005 17:54:40 GMT):
How do I to move our data stored on an external server (over the Internet)
in a mySql database to MS Access on our office computer.
You need to install the MySQL ODBC driver (available at mysql.com), create
an ODBC source and then use the Access import tables feature.
I would like to remove the data from the
Net and store it on our computer for security reasons.


Use your favourite MySQL client to create an SQL dump and store the
resulting file in your hard disk.
--
-- Á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
--
Jul 17 '05 #2

P: n/a
easier approach if you don't have to move data that often:

phpMyAdmin has an export feature that exports data out of mysql in many
formats, for instance xml or csv, which can easily be imported into
access.

micha

Jul 17 '05 #3

P: n/a
Ken
I successfully installed the ODBC drive in Windows 2000
During the configuration, the Connector is asking for the server name.
Data Source Name: I just typed in any name. OK?
Description: not important
Server:
If I use localhost, I expect the connector will look at my computer. How do
I call out a website address plus the server name?
host282.domainname.com/~xxxxx/localhost ????
https://host282.domainname.com/~xxxxx/localhost ???

The database is at host282.domainname.com/~xxxxx Do I move the 282 to the
port option?

Ken
"Alvaro G Vicario" <al******************@telecomputeronline.com> wrote in
message news:fy*****************************@40tude.net...
*** Ken wrote/escribió (Wed, 27 Apr 2005 17:54:40 GMT):
How do I to move our data stored on an external server (over the Internet) in a mySql database to MS Access on our office computer.


You need to install the MySQL ODBC driver (available at mysql.com), create
an ODBC source and then use the Access import tables feature.
I would like to remove the data from the
Net and store it on our computer for security reasons.


Use your favourite MySQL client to create an SQL dump and store the
resulting file in your hard disk.
--
-- Á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
--

Jul 17 '05 #4

P: n/a
*** Ken wrote/escribió (Wed, 27 Apr 2005 23:19:34 GMT):
Server:
If I use localhost, I expect the connector will look at my computer. How do
I call out a website address plus the server name?
You don't call a website address. You are to connect to a MySQL server, not
a web server. They're different services.
The database is at host282.domainname.com/~xxxxx
Weird... MySQL databases are not accessed through directories, they're
merely accessed through their names. What happens if you use
host282.domainname.com as server name?

Also, please note that your hosting service does not necessarily allow
remote connections to database server.
Do I move the 282 to the port option?


Why should you?
--
-- Á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
--
Jul 17 '05 #5

P: n/a
Ken
"Alvaro G Vicario" <al******************@telecomputeronline.com> wrote in
message news:tk****************************@40tude.net...
*** Ken wrote/escribió (Wed, 27 Apr 2005 23:19:34 GMT):
Server:
If I use localhost, I expect the connector will look at my computer. How do I call out a website address plus the server name?
You don't call a website address. You are to connect to a MySQL server,

not a web server. They're different services.
The database is at host282.domainname.com/~xxxxx


Weird... MySQL databases are not accessed through directories, they're
merely accessed through their names. What happens if you use
host282.domainname.com as server name?

Also, please note that your hosting service does not necessarily allow
remote connections to database server.


I just received the following email from my hosting service. You were right
on the mark.
We do not support ODBC and DNS connection. But you can use DSN-less

connection.

I know how to move data into and out of a MySQL database. But can a script
automatically append the data into Access?

Ken

Jul 17 '05 #6

P: n/a
>>>We do not support ODBC and DNS connection. But you can use DSN-less
connection.

I know how to move data into and out of a MySQL database. But can a script
automatically append the data into Access?


Use mysqldump. It produces a series of SQL statements that puts
the data into a database. If you use the right options (e.g.
--compatible=mssql on MySQL 4.1 or higher) you can probably get
mysqldump to leave out the MySQL-specific stuff so MS Access can
swallow it.

Now, is there a way (command-line utility) for MS Access to take a
file full of SQL statements and run it? If so, do this from your
script.

Gordon L. Burditt
Jul 17 '05 #7

This discussion thread is closed

Replies have been disabled for this discussion.