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]

Re: MySQL

In article <Q3sdc.25036$YC 5.3763@twister. rdc-kc.rr.com>,
kkrolski@wi.rr. com says...[color=blue]
> 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.
>
>
>
>[/color]


Use ODBC and you can live link the MySQL into Access

[Ken]

Re: MySQL

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

"Ima Lostsoul" <me@myprovider. com> wrote in message
news:MPG.1ae06c d469d75b129896e 3@netnews.comca st.net...[color=blue]
> In article <Q3sdc.25036$YC 5.3763@twister. rdc-kc.rr.com>,
> kkrolski@wi.rr. com says...[color=green]
> > 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[/color][/color]
a[color=blue][color=green]
> > *.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[/color][/color]
would[color=blue][color=green]
> > not be manually imported into Access but accept the data when it is sent[/color][/color]
to[color=blue][color=green]
> > Access.
> >
> > Where would I find information on the script needed to do this?
> >
> > Thanks.
> >
> >
> >
> >[/color]
>
>
> Use ODBC and you can live link the MySQL into Access[/color]

[Ima Lostsoul]

Re: MySQL

In article <SLOdc.26217$YC 5.10241@twister .rdc-kc.rr.com>,
kkrolski@wi.rr. com says...[color=blue]
> Can I link MySQL into Access even if MySQL is on an external server, contact
> over the net?
>
> "Ima Lostsoul" <me@myprovider. com> wrote in message
> news:MPG.1ae06c d469d75b129896e 3@netnews.comca st.net...[color=green]
> > In article <Q3sdc.25036$YC 5.3763@twister. rdc-kc.rr.com>,
> > kkrolski@wi.rr. com says...[color=darkred]
> > > 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[/color][/color]
> a[color=green][color=darkred]
> > > *.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[/color][/color]
> would[color=green][color=darkred]
> > > not be manually imported into Access but accept the data when it is sent[/color][/color]
> to[color=green][color=darkred]
> > > Access.
> > >
> > > Where would I find information on the script needed to do this?
> > >
> > > Thanks.
> > >
> > >
> > >
> > >[/color]
> >
> >
> > Use ODBC and you can live link the MySQL into Access[/color]
>
>
>[/color]

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