Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Convert from dbf to text
Message
From
20/08/2007 02:43:15
 
 
To
19/08/2007 09:27:46
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Visual FoxPro:
VFP 9 SP1
OS:
Windows XP
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01249004
Message ID:
01249078
Views:
16
hi,
thank you very much,

>>hi all,
>>
>>i try to convert dbf to text file as this code,
>>
>>
>>
>>CLOSE all
>>thisform.text1.value=GETFILE('dbf')
>>USE alltrim(thisform.text1.value) in 0
>>
>>gcDelimName = ALIAS( ) + '.txt'
>>gcDelimFile = PUTFILE('text_file:', gcDelimName, 'txt')
>>IF EMPTY(gcDelimFile)
>>   CANCEL
>>ENDIF
>>COPY TO (gcDelimFile)    && Create not delimited file
>>COPY TO (gcDelimFile) TXT  && error
>>SET DEFAULT TO d:\yousef
>>
>>
>>thanks
>
>Check the help for the COPY TO command. There is no TXT option. You probably want something like:
>
>COPY TO (gcDelimFile) DELIMITED WITH "" WITH BLANK
>
>
>VFP Help:
>
>COPY TO FileName [DATABASE DatabaseName [NAME LongTableName]]
>   [FIELDS FieldList | FIELDS LIKE Skeleton | FIELDS EXCEPT Skeleton]
>   [Scope] [FOR lExpression1] [WHILE lExpression2]
>   [ [WITH] CDX ] | [ [WITH] PRODUCTION ] [NOOPTIMIZE]
>   [ [TYPE] [ FOXPLUS | FOX2X | DIF | MOD | SDF | SYLK | WK1 | WKS | WR1
>   | WRK | CSV | XLS | XL5 | DELIMITED [ WITH Delimiter | WITH BLANK
>   | WITH TAB | WITH CHARACTER Delimiter ] ] ] [AS nCodePage]
>
Previous
Reply
Map
View

Click here to load this message in the networking platform