LinuxQuestions.org
Help answer threads with 0 replies.
Go Back   LinuxQuestions.org > Forums > Non-*NIX Forums > Programming
User Name
Password
Programming This forum is for all programming questions.
The question does not have to be directly related to Linux and any language is fair game.

Notices


Reply
  Search this Thread
Old 06-10-2003, 08:35 PM   #1
mychl
Member
 
Registered: Jul 2001
Location: Earth
Posts: 164

Rep: Reputation: 30
mysql and access


Anyone ever succesfully generate an MS Access file from a mysql db?

Trying to port my production system to linux for easier tracking, I need to store data in mysql, but then generate an Access file from it.....

Thanks
 
Old 06-10-2003, 10:01 PM   #2
Qzukk
Member
 
Registered: Jun 2003
Posts: 132

Rep: Reputation: 15
It's not going to directly work like that. As far as I know, only microsoft and maybe a few big companies know how to make access files, and they aren't sharing.

Your best bet is going to be to write or find a program to export from MySQL to a format that microsoft Access will read (like a CSV flat file) then import that into Access. If you know Java, you might be able to find JDBC stuff for Access and for MySQL, and write a java app to use JDBC to get the stuff out of MySQL and then put it into access. Could also be done with ODBC.
 
Old 06-11-2003, 07:00 PM   #3
mychl
Member
 
Registered: Jul 2001
Location: Earth
Posts: 164

Original Poster
Rep: Reputation: 30
Thanks for the insight....

 
  


Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off



Similar Threads
Thread Thread Starter Forum Replies Last Post
MySQL vs. Access Zebe General 12 10-14-2005 01:47 AM
How access MySQL by MySQL Administrator? treotan Linux - Newbie 5 12-04-2004 11:17 PM
Access to Mysql munna_502 Linux - Software 2 04-20-2004 04:51 PM
from access to mysql ? abd_bela Programming 1 02-12-2004 08:57 AM
MySQl access from C++ rob99 Programming 6 06-23-2003 02:25 PM

LinuxQuestions.org > Forums > Non-*NIX Forums > Programming

All times are GMT -5. The time now is 03:45 AM.

Main Menu
Advertisement
My LQ
Write for LQ
LinuxQuestions.org is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
Syndicate
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
Open Source Consulting | Domain Registration