LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default converting a file to EXCEL from FoxPro.

I'm using Visual FoxPro 6.0 and EXCEL 2003. I created a query wit
FoxPro 6.0 and copied it to EXCEL 2003. The Table size is 3382
records and it only copied 16384 records. Why is this

Here is the code

close data al
set talk o
set dele o

SELECT
USE "c:\documents and settings\bartech\my documents\fmpdata\softwar
code\fmp reports\fmptables\line02.dbf" share

select *
from line02
group by 3,4,5,6
order by 3,4,5
into cursor

select

copy to c:\line02wmake&model.xls type xl

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
query foxpro in excel 2007 steve h Excel Discussion (Misc queries) 0 May 26th 09 04:29 PM
how to convert excell file into dbf for foxpro agnelo rodrigues Excel Discussion (Misc queries) 2 April 3rd 08 10:38 PM
Converting Excel file to text delimited file Kiran Veeramallu[_2_] Excel Discussion (Misc queries) 3 May 1st 07 07:04 PM
Excel get external data from Foxpro with .dbf & .ftp Raymondwu Links and Linking in Excel 0 December 24th 06 07:19 AM
compatibilidad de excel con foxpro francis garcia valdes Excel Programming 0 October 9th 04 02:57 AM


All times are GMT +1. The time now is 11:48 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"