MySQL Help
 
Forums: » Register « |  User CP |  Games |  Calendar |  Members |  FAQs |  Sitemap |  Support | 
User Name:
Password:
Remember me
Go Back   Dev Shed ForumsDatabasesMySQL Help

Reply
Add This Thread To:
  Del.icio.us   Digg   Google   Spurl   Blink   Furl   Simpy   Y! MyWeb 
Thread Tools Search this Thread Rate Thread Display Modes
 
Unread Dev Shed Forums Sponsor:
SlickEdit: Code in over 40 languages across 7 platforms. SlickEdit’s unmatched power, speed, and flexibility allows even the most accomplished developers to write better code faster. Download a free trial today!
  #1  
Old March 27th, 2000, 08:53 AM
tony styles tony styles is offline
Junior Member
Dev Shed Newbie (0 - 499 posts)
 
Join Date: Mar 2000
Posts: 10 tony styles User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: < 1 sec
Reputation Power: 0
I have MySQL 3.22.xx loaded and running as
a server. I need to be able to get MySQL to
execute a large query (such as a summary)
and then send the results back to MSAccess97
which will then generate reports from it.

I have found no way of storing the results of
a MySQL query - so that Access can get them easily - without having to create a C API to
do this.

Does anyone know of a way around this?
Thanks.

Reply With Quote
  #2  
Old March 28th, 2000, 10:18 AM
rycamor rycamor is offline
Gödelian monster
Dev Shed Regular (2000 - 2499 posts)
 
Join Date: Jul 1999
Location: Pembroke Pines, Florida, USA
Posts: 2,300 rycamor User rank is Sergeant Major (2000 - 5000 Reputation Level)rycamor User rank is Sergeant Major (2000 - 5000 Reputation Level)rycamor User rank is Sergeant Major (2000 - 5000 Reputation Level)rycamor User rank is Sergeant Major (2000 - 5000 Reputation Level)rycamor User rank is Sergeant Major (2000 - 5000 Reputation Level)rycamor User rank is Sergeant Major (2000 - 5000 Reputation Level) 
Time spent in forums: 3 Days 3 h 2 m 4 sec
Reputation Power: 43
Assuming your database is located on a Unix system, put your query commands in an external text file, and run the Mysql shell non-interactively (you pipe your commands in, and pipe the putput out), in which case you can pipe the output to any text file you want. For example the following command would be run from the standard command shell, not from the mysql command shell.

bash$ mysql database_name < script.sql > output.tab

Then mysql would run the query in script.sql, and output the results to output.tab, which would be delimited by whatever options you choose in your sql script.

See http://web.mysql.com/Manual_chapter...ools.html#mysql

Reply With Quote
  #3  
Old March 30th, 2000, 04:29 AM
tony styles tony styles is offline
Junior Member
Dev Shed Newbie (0 - 499 posts)
 
Join Date: Mar 2000
Posts: 10 tony styles User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: < 1 sec
Reputation Power: 0
Thanks, that will work.
What I was also wondering was once you
have a file with a set of results from a query, how do you then base another query on them?

Reply With Quote
Reply

Viewing: Dev Shed ForumsDatabasesMySQL Help > Sending Results of a MySQL Query to MSAccess


Thread Tools  Search this Thread 
Search this Thread:

Advanced Search
Display Modes  Rate This Thread 
Rate This Thread:


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

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
View Your Warnings | New Posts | Latest News | Latest Threads | Shoutbox
Forum Jump


Forums: » Register « |  User CP |  Games |  Calendar |  Members |  FAQs |  Sitemap |  Support | 
  
 





© 2003-2008 by Developer Shed. All rights reserved. DS Cluster 1 hosted by Hostway