Steps:
Step 1: Download and install the MyODBC software from the MySQL website.
Step 2: Configure a DSN to connect to your MySQL server.
(This can be achieved by going to
Control Panel => Data Sources (Win98, ME) or
Control Panel => Administrative Tools => Data Sources
(Win2000, XP or like))
Step 3: Go to MS Access and do the following:
File ====> Get External Data ====>> Link Tables
Under files of Type ..... Choose ODBC and a window will be opened to
ask you which ODBC you want to use.
Choose the one you created in Step 2.
At this time, a list of available tables will be shown,
choose the tables you want to work with.
You almost done now and you may start creating reports in your Access as if
the tables were in Access. In fact a link is created for each table you
choose.
Hope to be helpful (if this helps you, please let me know)
Thanks
Emery
----- Original Message -----
From: "Wang Feng" <[EMAIL PROTECTED]>
To: "Director General: NEFACOMP" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>;
<[EMAIL PROTECTED]>
Sent: Wednesday, October 08, 2003 10:16
Subject: Re: printing reports
>
> > Unfortunately, they have not implemented a reporting tool in that
client.
>
> that's the problem, as I was trying to find some sql commands to edit the
> report, such as report titles.
>
>
> >Do you know some programming language? Like Visual Basic, C, C++, Java,
> PHP,
>
> i know them, but as I mentioned earlier, I was trying to find some sql
> commnds to achieve that. and i don't wanna print the report with the help
of
> a programming language since i think if we can solve problems using SQL
> itself then it costs less.
>
>
> > Are you familiar with MS Access? If yes, you can use Access to work with
> > MySQL data.
> > If you have Access installed, just let me know and I will send you Step
by
> > Step Instructions.
>
> yes, please send me the Step by Step Instructions. i do want to give it a
> try with Access although it's not free.
>
>
>
> cheers,
>
> feng
>
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
>
>
>
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
