Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion Groups
Database Servers
DB2InformixIngresMS SQLOraclePervasive.SQLPostgreSQLProgressSybase
Desktop Databases
FileMakerFoxProMS AccessParadox
General
General DB TopicsDatabase Theory
Related Topics
Java Development.NET DevelopmentVB DevelopmentMore Topics ...

Database Forum / FoxPro / Reports and Printing / September 2003

Tip: Looking for answers? Try searching our database.

report form to DBF

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Mike Hunt - 22 Sep 2003 09:41 GMT
Can I send the output from a report to already created a DBF file instead of
TXT/ASCII format?

Thanks
Mike
Rick Bean - 22 Sep 2003 13:53 GMT
Mike,
No, but if you've already got the data in tables (or better yet a single cursor), it shouldn't be hard to copy or select it into another table. (You may have to go to an intermediate table so you can APPEND it, if the existing table already has data.)

Rick

> Can I send the output from a report to already created a DBF file instead of
> TXT/ASCII format?
>
> Thanks
> Mike
Lee Mitchell - 22 Sep 2003 22:20 GMT
Hi Mike:

Rick is correct; you cannot go from report output directly to table.  
However, there are some tools in the Download section of
www.universalthread.com that allow you to send the output of a report to an
Excel spreadsheet.  Once in Excel format, you could use the APPEND FORM or  
IMPORT commands to get the data into a DBF file.  As long as the report
does not output more data than an Excel spreadsheet can handle, you could
use this technique.

I hope this helps.

This posting is provided "AS IS" with no warranties, and confers no rights.

Sincerely,
Microsoft FoxPro Technical Support
Lee Mitchell

*-- VFP8 HAS ARRIVED!! --*
Read about all the new features of VFP8 here:
  http://www.universalthread.com/VisualFoxPro/News/VFP8Release.asp
Purchase VFP8 here:
  http://shop.microsoft.com/Referral/Productinfo.asp?siteID=11518

Keep an eye on the product lifecycle for Visual FoxPro here:
http://support.microsoft.com/default.aspx?id=fh;[ln];lifeprodv
  - VFP5 Mainstream Support retires June 30th, 2003
  - VFP6 Mainstream Support retires Sept. 30th, 2003

>Mike,
>No, but if you've already got the data in tables (or better yet a single
cursor), it shouldn't be hard >to copy or select it into another table.
(You may have to go to an intermediate table so you can >APPEND it, if the
existing table already has data.)
>Rick
> Can I send the output from a report to already created a DBF file instead of
> TXT/ASCII format?
>
> Thanks
> Mike
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2009 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.