MySQL

[Ken]

I would like to send data from MySQL database directly into Access 2000
without manually clicking on the (Get External Data) to import the data.

I would like to automatically force access to accept data through either a
*.php, *.js or *.txt file or some other file.

Can this be done?

I would like to send data to access (it would be running). The data would
not be manually imported into Access but accept the data when it is sent to
Access.

Where would I find information on the script needed to do this?

Thanks.

[Ima Lostsoul]

In article <Q3******************@twister.rdc-kc.rr.com>,
kk******@wi.rr.com says...

I would like to send data from MySQL database directly into Access 2000
without manually clicking on the (Get External Data) to import the data.

I would like to automatically force access to accept data through either a
*.php, *.js or *.txt file or some other file.

Can this be done?

I would like to send data to access (it would be running). The data would
not be manually imported into Access but accept the data when it is sent to
Access.

Where would I find information on the script needed to do this?

Thanks.

Use ODBC and you can live link the MySQL into Access

[Ken]

Can I link MySQL into Access even if MySQL is on an external server, contact
over the net?

"Ima Lostsoul" <[e-mail]> wrote in message
news:MP************************@netnews.comcast.ne t...

In article <Q3******************@twister.rdc-kc.rr.com>,
kk******@wi.rr.com says...

I would like to send data from MySQL database directly into Access 2000
without manually clicking on the (Get External Data) to import the data.

I would like to automatically force access to accept data through either a *.php, *.js or *.txt file or some other file.

Can this be done?

I would like to send data to access (it would be running). The data would not be manually imported into Access but accept the data when it is sent to Access.

Where would I find information on the script needed to do this?

Thanks.

Use ODBC and you can live link the MySQL into Access

[Ima Lostsoul]

In article <SL*******************@twister.rdc-kc.rr.com>,
kk******@wi.rr.com says...

Can I link MySQL into Access even if MySQL is on an external server, contact
over the net?

"Ima Lostsoul" <[e-mail]> wrote in message
news:MP************************@netnews.comcast.ne t...

In article <Q3******************@twister.rdc-kc.rr.com>,
kk******@wi.rr.com says...

I would like to send data from MySQL database directly into Access 2000
without manually clicking on the (Get External Data) to import the data.

I would like to automatically force access to accept data through either a *.php, *.js or *.txt file or some other file.

Can this be done?

I would like to send data to access (it would be running). The data would not be manually imported into Access but accept the data when it is sent to Access.

Where would I find information on the script needed to do this?

Thanks.

Use ODBC and you can live link the MySQL into Access

Yep I do it all the time! Go get MyODBC. Set up an ODBC Connect. Then
just link the data.