[AccessD] Saving Query From VB6 into Access

Not sure this can done from VB, you can do it from Access with 
application.LoadAsText or
application.SaveAsText.  However if you did manage to move the SQL into 
an Access Query, how do you compile it from within VB.

paul.hartland at fsmail.net wrote:

>To all,
>
>I'm sure I have either done this before or have heard it can be done.  I have a Visual Basic 6 front-end which links to an Access back-end, what I want to do is build a SQL select statement on the fly in VB6 (I have got this far), and then I need to save it as a query into the Access database.
>
>Anyone have any ideas on how I go about this.....
>
>Thanks in advance.
>
>Paul 
>
>__________________________________________________________________________
>Join Freeserve http://www.freeserve.com/time/
>
>Winner of the 2003 Internet Service Providers' Association awards for Best Unmetered ISP and Best Consumer Application.
>
>
>_______________________________________________
>AccessD mailing list
>AccessD at databaseadvisors.com
>http://databaseadvisors.com/mailman/listinfo/accessd
>Website: http://www.databaseadvisors.com
>
>  
>