Conversion of MS Access queries to SQL queries

Hi All,
Anyone knows of a utility or software that will convert MS Access
queries to SQL Queries. I need to convert my existing ms access
queries to SQL queries as i need to use them in a software which only
takes SQL queries. I tried to copy and paste "SQLVIEW" of the queries
from MSaccess but they dont' work as they require modifications.
I don't have much knowledge of SQL queries, wondering if someone can
point me in right direction.

Thx

0
raonhassan
6/7/2007 3:41:23 PM
access.queries 6343 articles. 1 followers. Follow

1 Replies
694 Views

Similar Articles

[PageSpeed] 16

In article <1181230883.726006.250120@q66g2000hsg.googlegroups.com>, 
raonhassan@yahoo.com says...
> Hi All,
> Anyone knows of a utility or software that will convert MS Access
> queries to SQL Queries. I need to convert my existing ms access
> queries to SQL queries as i need to use them in a software which only
> takes SQL queries. I tried to copy and paste "SQLVIEW" of the queries
> from MSaccess but they dont' work as they require modifications.
> I don't have much knowledge of SQL queries, wondering if someone can
> point me in right direction.
> 
> Thx
> 
> 
Unless someone comes through with a tool to convert queries from Access SQL to 
SQL Server SQL, you will need to do it yourself.  Maybe post one of the SQL 
here and see if anyone can convert it for you. Then you can learn by example.  
Just an idea.

Maybe someone will suggest a more appropriate user group for your question.
0
Michael
6/7/2007 11:11:26 PM
Reply:

Similar Artilces:

Limitied Access user
Is there a way to set up a user in Ex2k so they have access to only calendar and internal mail? Our client doesn't want the user to receive or send external mail. Thanks for any help "Sarah M" <sarahm@NO_ibm_SPAM.com> wrote: >Is there a way to set up a user in Ex2k so they have access to only calendar >and internal mail? Our client doesn't want the user to receive or send >external mail. Create another Recipient Policy and use a SMTP address like %m@ibm.local. Then select a user property that you can populate with some unique value that will be assigned t...

Conversions
Hello! I work as an Information Specialist. Majority of our job requests involve conversions. We just received an Adobe Acrobat pdf in which the original document was created in MAC OS. The conversion was successful through Omni Page as we only needed to capture text to convert to a Word document. I was wondering is there any other suggestions you can recommend for conversions from other softwares such as MAC. Thanks so much for your time. A PDF file is a PDF file, no matter which OS was used when the file was created. If you want conversions for specific Mac formats t...

SQL Express 2005 concurrent use of hosted and user instances
We have an application that makes use of a SQL Express 2005 database for temporary storage of transaction data. The database is hosted locally (as the default instance name SQLEXPRESS) and is accessed via TCP using .NET native client support. Over several years and hundreds of installations this was worked flawlessly, until recently. We have been experiencing periodic corruption issues across a large number of related installations. The corruption has been observed in one of two forms: 1) the MDF and LDF files get out of sync. 2) The master database gets damaged rendering...

VC6 -> VC2005 conversion problem
Hello, I'm converting my project from VC++6 to VC++2005. among many compilation errors now solved, that one is stucking me : I have that template : template <class T> class TLineApproximator { public: //! \name Structures and typedefs //@{ //! 2D homogenous point struct SHomog { public: SHomog(T _x=0, T _y=0, T _w=1) { x=_x; y=_y; w=_w;}; T x; T y; T w; }; //! 2D point struct SPoint { public: SPoint(T _x=0, T _y=0) { x=_x; y=_y;}; static void CrossProduct( const SPoint& p, const SPoint& q, SHomog& r) { r.w = p.x * q.y - p.y * q.x; r.x...

Information pane in an MS Word window
Hi folks, Usually when working in word, the bottom of the window pane (grey bar) conveys standard information such as the # of pages in the document, coordinates for the cursor in the document, whether or not the "Insert" buttom is in use (symbol OVR). Thank you. This is called the "status bar" and in Word 2003 and earlier, can be toggled on and off at Tools | Options | View. In Word 2007 (and presumably 2010), it is always displayed. -- Suzanne S. Barnhill Microsoft MVP (Word) Words into Type Fairhope, Alabama USA http://word.mvps.org "Na...

Access to others inbox #2
I posted this before on 12/24 but my post disappeared after one response. We have a single server environment with Win2000 server and Exchange 2000. We just found out recently that through Outlook, everyone can open all other user's mailbox folders. The only exception is the Administrator. He cannot open anyone's. There seems to be no security. I ran throught the typical permissions for inboxes and they are properly set to "none". I checked the file permissions on the M: drive as well as the Exchsrv folder and I don't see any glaring problems but I'm not sure...

synching access and outlook
How can I 1. automate synching, 2. or even just one-way dump my msAccess contacts table into Outlook, replacing all existing Outlook contacts with my msAccess contacts table each time? ...

Crosstab query totals
Need some help, I have a crosstab query that returns the following data see sql below, what I need is to total all gearbox types that are R and 37 and R and 27 and R and 47 etc. an example R and RF 27 total = 492 <> 1 2 4 SubTotals R 27 20 26 303 12 361 R 37 6 66 307 8 387 R 47 8 87 424 2 521 R47R 37 2 2 R57R 37 3 2 5 R67R 37 1 1 2 R77R 37 19 19 RF 27 4 17 109 1 131 RF 37 1 11 76 88 RF 47 1 25 39 65 TRANSFORM Sum(InspectionLog.Quantity) AS SumOfQuantity SELECT Sum(InspectionLog.Quantity) AS SubTotals, InspectionLog.GearboxType ...

Postcard conversion...
I have been printing 5 1/2 x 8 1/2 cardstock postcards and would now like to convert my 2 per page size to 4 per page or 4 x 6 size postcards. How can I convert my larger graphics and text w/o having to go thru the madness of cutting, pasting, and resizing everything to the smaller size postcard? Thanking you in advance. Frank Engels ...

M2004 Deluxe-TIRA to Roth Conversion Question
Hi, I am using MS Money 2004 Deluxe. I did a Traditonal IRA conversion to a Roth back on Nov 24th. The conversion was with the same mutual fund, ticker symbol. How do I do the transaction within Money to effectively close the TIRA and have the Roth Start on 11/24/08? I want the converted amount, for tax purposes, to show up on the Money Home page. Thanks! Transfer Out investment activity? "Mike" <Mike@nothere.com> wrote in message news:%23UAtIoDaJHA.3908@TK2MSFTNGP06.phx.gbl... > I am using MS Money 2004 Deluxe. I did a Traditonal IRA conversion to a > Roth b...

Access 2003 Mail Merge to Word 2003 using query to locate the specific record being displayed
After spending ALL DAY searching the entire WEB I have found a lot of posts asking this same question but not one answer. I thought I's throw it up again. The button on my form does this. * From Mergit() * Dim objWord As Word.Document Set objWord = GetObject("H:\Contract Admin Database\Merge Documents \WIP\Closings\Closing Packet Documents\Test - closing packet EM.doc", "Word.Document") objWord.Application.Visible = True ' Set the mail merge data source as the Northwind database. objWord.MailMerge.OpenDataSource _ Name:="H:\Contract Adm...

MS Word hangs, won't even force quit, so I must restart
I have had this problem from the beginning. 75% of the time, when I quite Word, it will not quit. I get the spinning ball, and have to restart. In article <96516119.0309161147.7044a096@posting.google.com>, dnmjr1@earthlink.net (David) wrote: > I have had this problem from the beginning. 75% of the time, when I > quite Word, it will not quit. > I get the spinning ball, and have to restart. Have you applied at least the 10.1.2 Office update from Mactopia downloads: http://www.microsoft.com/mac/download/default.asp ?? If so, how long are you waiting? Are you on a netw...

prepared sql statement
i had made the simple application to insert a single record to visula foxpro table(assume that table is having only one field) using prepared statement but now when i have to insert more than one data each time i have to bind that row and each time i have to use SQLExecute function, so is it possible to insert multiple data by just using single time execution of SQLExecute() function if it is possible then plz help me. kaushal wrote: > i had made the simple application to insert a single record to visula > foxpro table(assume that table is having only one field) using prepared > sta...

Locking a single record or row in access subform
Hi, I Hope you guys can help me. I need to lock a single record in a suborm. The code I have is (in the subform) I basically need to allow only one addition to the table, after this they should only be allowed to edit the record, no further additions. The problem is that it locks all of the records as it is locking the table and not the individual row for each subform record. Private Sub Form_Current() Dim rs As Recordset rs.Clone rs.MoveLast If rs.RecordCount = 0 Then Me.AllowAdditions = True Me.AllowEdits = True Else Me.AllowAdditions = False Me.AllowEdits = True End Sub What am I doin...

Password problem opening MS Money file
Normally, MS Money 2007 displays the login page as it starts and a simple click gets me in. A few days ago, the page looked a bit different and would not accept my password. It seems like it got disconnected from the Windows Live account. The backup file (that it saves on close) worked, however (phew). I've been using MSM for years without any problem like this before. Gary Davis In microsoft.public.money, GarDavis wrote: >Normally, MS Money 2007 displays the login page as it starts and a >simple click gets me in. A few days ago, the page looked a bit >different and would no...

Windows Mobile 2003/Access Runtimes modules
Is it possible to run Access (Access 2002/2003) runtime modules on a PDA (Windows Mobile 2003). Where Can I get More information about this? The access runtime is not different then the full version, except that you can't modify forms etc. In some versions of the runtime, it was a 150 meg install, and required a re-boot. This is not exactly the kind of software that would install and run on a pda. So, no...there is not a ms-access that runs on a pda. There are a number of good database products for pc's..and quite a few options for syncing with ms-access. Here is some links to get...

Cannot login into MS CRM
Hi! I tried installing MS CRM on a Win 2003 server. After install I tried accessing the loader.aspx page and entered my credentials and got this error. Access is denied Not enough privilege to access MS CRM object or perform the requested operation When I had earlier installed it was working fine. I was able to login, however, I had problems installing the Sample Database. So I uninstalled and reinstalled MS CRM, mapped the sample users afresh and the sample database install went fine. However, now I get the above error when I try to login. Any ideas? Thanks ...

Convert Access 2000 to Access 2.0
I am working for a company that is running Access 2.0 ( seriously ) I want to modify an existing report in access 2000 but then export it so that I can use it in Access 2.0 Similarly, I want to export a query created in 2000 ( or 97 ) and export it so that I can use it in Access 2.0 Anyone know how to accomplish this feat ? Thanks in advance -- ============================== I don't believe it's possible. You can get data from Access 2000 to Access 2, but I think that's it. -- Doug Steele, Microsoft Access MVP http://I.Am/DougSteele (no e-mails, please!) "D"...

Can I prevent others from copying my MS Access DB Program
I deleloped a database program for small business that i sell and would like to prevent these business from making copies of my MS Access DB and giving them to similar business. How can I do this? "Todos Menos [MSFT]" <todos_menos_msft@hotmail.com> wrote:Todos Menos is not a Microsoft employee. This posting is by A a r o nK e m p f.Tony-- Tony Toews, Microsoft Access MVP Please respond only in the newsgroups so that others can read the entire thread of messages. Microsoft Access Links, Hints, Tips & Accounting Systems at http://www.granite.ab.ca/accsmstr.htm Faz <F...

TYPE CONVERSION
My goal is to automatically update the End Date to display the create date from a record previously reported. For example the end date for the first record listed below should be 9/24/2009 12:41:00 PM and the end date for the third record listed below should be 8/21/2009 9:00:00 AM. ID CATEGORY RANGE CREATE_DATE END_DATE 3426 Service 24 months 9/15/2009 9:35:00 AM 3426 Service 24 months 9/24/2009 12:41:00 PM 3426 Service 36 months 8/20/2009 12:23:00 PM 3426 Service 36 months 8/21/2009 9:00:00 AM I have the query listed belo...

Collecting the Data entered onto a form into a access table.
I have designed a form in outlook 2003 and want to collect he data in a access table when the form is used to send email. Can any one please help me as I am stuck. I have linked the table to the form but nothing happens when you use the form and send a email. You will need to write code. See http://www.outlookcode.com/d/database.htm for links to samples, etc -- Sue Mosher, Outlook MVP Author of Microsoft Outlook Programming - Jumpstart for Administrators, Power Users, and Developers http://www.outlookcode.com/jumpstart.aspx "Claude Brandon" <claude@umban...

new to MS CRM
Hi all!, I would like to find out if it is estrictly necessary to install MS CRM on the small business server to start playing with the SDK, and developing with it, what is the latest version available from MSDN, and what is the preferable programming language to use. Can anybody help me on this? Thanks, Carlos "Carlos" <ch_sanin@yahoo.com> wrote in message news:%23LiJlNDbFHA.228@TK2MSFTNGP12.phx.gbl... > Hi all!, > > I would like to find out if it is estrictly necessary to install > MS CRM on the small business server to start playi...

Saving data to SQL from unmanaged C++ using XML/webservice
I have a Webservice written in C# that provides data to both a web browser through ASP.net and to a VC++ client. I have been able to retrieve data from SQLServer and passing to my unmanaged C++ client as XML without a problem using the SqlDataAdaptor and the DataSet. I am a bit confused how to construct the XML to pass to the Webservice to save data to SQL Server from my VC++ unmanaged client. the client VC++ code: HRESULT CStaffAccess::Save(CStff* pStaff) { CString strXML CreateXML(pStaff); BSTR bstrXMLString = strXML.AllocSysString(); BSTR bstrResult; STMWebService...

Access And Tablet PC
Do you know if I can program Access to recognize hand writting? Do you know of good resources (libraries, sample apps, documentation to program Access on the tablet?) Thank you I think Access 2007 probably already supports handwriting. -Amy <hl383@hotmail.com> wrote in message news:093bd4d6-cb38-4871-9cf9-d51fe399cdce@e6g2000prf.googlegroups.com... > Do you know if I can program Access to recognize hand writting? Do > you know of good resources (libraries, sample apps, documentation to > program Access on the tablet?) > > Thank you When a couple of the guys in...

Conversations
I have searched for and got a list of 70 items in my inbox, which I now view as conversations, bbut the count at the bottom of the screen still shows '70 items'. Is there a quick and easy way to count the number of conversations, rather than the number of items? Thanks, G No. <george.walsh@doeni.gov.uk> wrote in message news:6798cc53-de91-4772-be4e-9de69dc45289@w40g2000hsb.googlegroups.com... >I have searched for and got a list of 70 items in my inbox, which I > now view as conversations, bbut the count at the bottom of the screen > still shows '70 items'. ...