Access

[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

[Alvaro G Vicario]

Re: Access

*** Ken wrote/escribió (Wed, 27 Apr 2005 17:54:40 GMT):[color=blue]
> 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.[/color]

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

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
--

[micha]

Re: Access

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

[Ken]

Re: Access

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.domainn ame.com/~xxxxx/localhost ????
https://host282.domainname.com/~xxxxx/localhost ???

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

Ken


"Alvaro G Vicario" <alvaro_QUITAR_ REMOVE@telecomp uteronline.com> wrote in
message news:fy1zalhsqp s4.102kfdw2bhzz k$.dlg@40tude.n et...[color=blue]
> *** Ken wrote/escribió (Wed, 27 Apr 2005 17:54:40 GMT):[color=green]
> > How do I to move our data stored on an external server (over the[/color][/color]
Internet)[color=blue][color=green]
> > in a mySql database to MS Access on our office computer.[/color]
>
> You need to install the MySQL ODBC driver (available at mysql.com), create
> an ODBC source and then use the Access import tables feature.
>[color=green]
> > I would like to remove the data from the
> > Net and store it on our computer for security reasons.[/color]
>
> 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
> --[/color]

[Alvaro G Vicario]

Re: Access

*** Ken wrote/escribió (Wed, 27 Apr 2005 23:19:34 GMT):[color=blue]
> 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?[/color]

You don't call a website address. You are to connect to a MySQL server, not
a web server. They're different services.
[color=blue]
> The database is at host282.domainn ame.com/~xxxxx[/color]

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

Also, please note that your hosting service does not necessarily allow
remote connections to database server.
[color=blue]
> Do I move the 282 to the port option?[/color]

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
--

[Ken]

Re: Access

"Alvaro G Vicario" <alvaro_QUITAR_ REMOVE@telecomp uteronline.com> wrote in
message news:tkq97ucgpo kl.xymvzal3w9g9 $.dlg@40tude.ne t...[color=blue]
> *** Ken wrote/escribió (Wed, 27 Apr 2005 23:19:34 GMT):[color=green]
> > Server:
> > If I use localhost, I expect the connector will look at my computer.[/color][/color]
How do[color=blue][color=green]
> > I call out a website address plus the server name?[/color]
>
> You don't call a website address. You are to connect to a MySQL server,[/color]
not[color=blue]
> a web server. They're different services.
>[color=green]
> > The database is at host282.domainn ame.com/~xxxxx[/color]
>
> Weird... MySQL databases are not accessed through directories, they're
> merely accessed through their names. What happens if you use
> host282.domainn ame.com as server name?
>
> Also, please note that your hosting service does not necessarily allow
> remote connections to database server.[/color]

I just received the following email from my hosting service. You were right
on the mark.
[color=blue][color=green]
>>We do not support ODBC and DNS connection. But you can use DSN-less[/color][/color]
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

[Gordon Burditt]

Re: Access

>>>We do not support ODBC and DNS connection. But you can use DSN-less[color=blue]
>connection.
>
>I know how to move data into and out of a MySQL database. But can a script
>automaticall y append the data into Access?[/color]

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=mssq l 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