Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: Stefan Wuebbe
  Where is Stefan Wuebbe?
 Hamburg
 Germany
 Stefan Wuebbe
 To: Eddie Ruiz
  Where is Eddie Ruiz?
 Hawthorne
 United States
 Eddie Ruiz
 Tags
Subject: RE: Help on exporting data from a form to ex
Thread ID: 394107 Message ID: 394142 # Views: 32 # Ratings: 0
Version: Visual FoxPro 9 SP2 Category: Forms
Date: Monday, December 30, 2013 10:24:50 PM         
   


> >
> > try this
> >
> >
select cus, cusname, transdate, transnum, checknum, tranpaid ;
> > from YOURTABLE ;
> > WHERE transdate >= m.ldStartdate AND transdate <=  m.ldenddate AND (..MORE CONDITIONS ...);
> > INTO CURSOR TEMP
> > 
> > SELECT TEMP
> > COPY TO c:\documents\test.xls type xl5 

> >
> >
> >
> >
> >
> > kulwant
> > (Help Save the TIGER. Save Wildlife. Live & let Live)
>
> Thank You soo much, it worked. Now i have another quick question is there a way that when exporting the transdate gets sorted from newest date to oldest?
>


You can add an SQL "... Order By ..." statement



hth
-Stefan

ENTIRE THREAD

Help on exporting data from a form to ex Posted by Eddie Ruiz @ 12/30/2013 6:11:39 PM
RE: Help on exporting data from a form to ex Posted by Kulwant Singh @ 12/30/2013 8:12:17 PM
RE: Help on exporting data from a form to ex Posted by Eddie Ruiz @ 12/30/2013 9:35:19 PM
RE: Help on exporting data from a form to ex Posted by Koen Piller @ 12/30/2013 9:54:11 PM
RE: Help on exporting data from a form to ex Posted by Stefan Wuebbe @ 12/30/2013 10:24:50 PM