| |||||||||||
 |
 |
| | LinkBack | Thread Tools | Search this Thread | Rate Thread | Display Modes |
(#1)
  |
| Member  Posts: 77 Join Date: Jun 2008 Location: UK | Extract Infomation ADODB -
01-03-2009, 01:38 PM
Afternoon All, I'm trying to run a query to extract data into Excel, basically to show different e-mail domain tickets to different tabs. i have written the query and it works as expected in mySQL Query Browser, but when i plug it into excel via a ADODB connection it either fails or gives completly different results. can anyone explain why a mySQL query can cause so many issues, also is there anyway of using a function similar to stored procedures in M$SQL. as this might be another way around the issue, if i can get the server to run the query instead of the client Thanks |
| |  |
|
(#2)
|
| Member Posts: 77 Join Date: Jun 2008 Location: UK |
01-03-2009, 03:31 PM
Figured it out, thanks
|
| | |
|
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
| |
Similar Threads | ||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Extract database data | JIAM | How do I? | 3 | 24-04-2008 04:21 PM |
| Can i extend the trial period and have these infomation also | squallpang | Presales Questions | 12 | 26-07-2007 09:59 AM |
Linear Mode
