473,287 Members | 1,659 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,287 software developers and data experts.

export tables from mysql -> ms access

hi there,

i've got a mysql database with a research data. i would like to get
some information from that database and save it as ms access database.

it will be a client feature. the client clicks a button -and
downloads ms access database with a certain information from the master
mysql database.

is it possible in php? how?

thanks a lot,
richard

Jan 21 '07 #1
4 2994
Richard wrote:
hi there,

i've got a mysql database with a research data. i would like to get
some information from that database and save it as ms access database.

it will be a client feature. the client clicks a button -and
downloads ms access database with a certain information from the master
mysql database.

is it possible in php? how?

thanks a lot,
richard
I would say to do this you're going to need to create an ActiveX control
(you are running on Windows hosting, aren't you?) to create the database
and registers it as an ODBC source. Than you can use the ODBC functions
to add your data (or just put that in the ActiveX control while you're
at it, also).

If you're not running on Windows hosting, you're out of luck.

Alternative, just save it in CSV format and let them do whatever they
want with it.

--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
js*******@attglobal.net
==================
Jan 21 '07 #2
Richard wrote:
it will be a client feature. the client clicks a button -and
downloads ms access database with a certain information from the master
mysql database.
This would not be easy. MS Access (MDB) files are a proprietary binary
format. Assuming a Linux/UNIX server, there is virtually no software able
to manipulate them. MDB Tools <http://mdbtools.sf.net/provides a Linux
ODBC driver for MDB databases, but this is read only, so while you can
use this ODBC driver to extract information from Access and insert it into
another database, you can't use it the other way around. They are working
on a read-write driver, but don't expect it any time soon (at least not in
a stable form!).

If you're running PHP on a Windows platform, with the Access DLLs
installed, you might have slightly better luck. The basic technique would
be, in advance, to create a blank database with all the right tables,
views, forms and so forth set up, but not populated with any data. Then,
when required, in PHP you could do a simple file copy of that database,
connect to it through ODBC, populate it with data, using INSERT queries,
then allow it to be downloaded.

Do the client really need it in Access format? Would it be a better idea
to provide them with a read-only phpMyAdmin-type solution, which they
could use to query?

Another idea, if you have control of the server's firewall, would be to
allow the client to connect directly to MySQL on TCP port 3306. You will
need to be very careful with security here. But this will allow them to
hook Access up to your live data, perform queries and run reports on it.
(You can create a special read-only user in MySQL for such purposes.)

--
Toby A Inkster BSc (Hons) ARCS
Contact Me ~ http://tobyinkster.co.uk/contact

Jan 21 '07 #3
i've got a mysql database with a research data. i would like to get
some information from that database and save it as ms access database.

it will be a client feature. the client clicks a button -and
downloads ms access database with a certain information from the master
mysql database.

is it possible in php? how?

Not really. But if it is always the same data, and if you do not mind
others to connect with one of your databases, there's an other approach:

You could make the exported tables accessible for others using normal
user management and imports these links through ODBC from MS-Access.

You can control what data is visible and what is not by giving access to
views, separate tables or even a separate database.

Those links can be either links or imports, so once a table is linked
from MS-Access, it can remain up-to date. The downside of this approach
is that you need MyODBC (can be downloaded from the MySQL site) on every
client that wants to link to your database.

Best regards
Jan 21 '07 #4
Richard wrote:
hi there,

i've got a mysql database with a research data. i would like to get
some information from that database and save it as ms access database.

it will be a client feature. the client clicks a button -and
downloads ms access database with a certain information from the master
mysql database.

is it possible in php? how?

thanks a lot,
richard
Richard,
Take a look at Navicat.com. The program is a MySQL front-end
application that has an 'Export Wizard' that features a conversion to MS
Access.

GW.
Jan 21 '07 #5

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

10
by: ls | last post by:
Hi All, I looking for help with ZODB data export to text file. I have file Data.fs (file becomes from Plone CMS) and I have to display content structure, data like intro, body of article, etc...
0
by: Priscilla Walther | last post by:
Hi All - I'm a newbie to the database area, but have inherited a MySQL database to manage along with my development duties. We have a very large MySQL database, and the designer of the...
1
by: Dave Crypto | last post by:
Hi there, SUMMARY: 1) When I use phpadmin to export a large database, the file created on my local PC never containes all the tables and information. It seems to max out at about 10mb. 2)...
1
by: Martin Herrman | last post by:
Hi all, I have installed MySQL on my Linux Mandrake 10 workstation; I didn't change any default values (except for the user-accounts). I used a CMS to create a website which I want to upload to...
5
by: Jandre | last post by:
To anyone that can help I have 2 MySQL databases that contain large amounts of tables. I need to be able to compare the data in the tables with older/newer versions of the tables. I figured the...
2
by: martha70 | last post by:
I’m running PHP MySQL (zen-cart) I’m looking for info on CSV files with data sets and how I can import these into MySQL. I found a number of topics involving simple CSV files and I tried a number of...
9
by: backups2007 | last post by:
please help. my code displays two errors that I'm having a hard time to resolve. here are the errors: first is: missing name in export statement; it generates an excel file. but this error...
4
by: sejal17 | last post by:
Dear Sir, Can you tell me how to export data from MySQL database to a xls file using php code?I have to export data from different tables of mysql database to a single xls file.Please help me!!! ...
15
by: Franz Marksteiner | last post by:
Hi folks, I am looking for the straightest way to export a whole MySql database, but all I can find is SQL statements to export specific tables. Any suggestions? -- Freundliche Grüße, Franz...
3
by: Edward Reid | last post by:
OK, I've been watching my DB grow and have known for a long time I would have to move the back end, but of course I waited until I started getting odd behavior (at about 1.92GB). So today I...
2
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 7 Feb 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:30 (7.30PM). In this month's session, the creator of the excellent VBE...
0
by: MeoLessi9 | last post by:
I have VirtualBox installed on Windows 11 and now I would like to install Kali on a virtual machine. However, on the official website, I see two options: "Installer images" and "Virtual machines"....
0
by: DolphinDB | last post by:
The formulas of 101 quantitative trading alphas used by WorldQuant were presented in the paper 101 Formulaic Alphas. However, some formulas are complex, leading to challenges in calculation. Take...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: Aftab Ahmad | last post by:
So, I have written a code for a cmd called "Send WhatsApp Message" to open and send WhatsApp messaage. The code is given below. Dim IE As Object Set IE =...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
by: marcoviolo | last post by:
Dear all, I would like to implement on my worksheet an vlookup dynamic , that consider a change of pivot excel via win32com, from an external excel (without open it) and save the new file into a...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.