Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Appending from a csv file
Message
 
To
21/09/2015 06:20:38
Lutz Scheffler
Lutz Scheffler Software Ingenieurbüro
Dresden, Germany
General information
Forum:
Visual FoxPro
Category:
Other
Environment versions
Visual FoxPro:
VFP 9 SP2
OS:
Windows 10
Network:
Windows 2008 Server
Database:
MS SQL Server
Application:
Web
Miscellaneous
Thread ID:
01624860
Message ID:
01624882
Views:
53
>Hi Colin,
>
>because you should do
>
Append From j:\global\awbshayes.csv DELIMITED
>Example:
>
>TEXT TO lcx NOSHOW
>"muh",1
>"mih",2
>ENDTEXT &&lcx
>STRTOFILE(lcx,'test.txt')
>
>CREATE CURSOR xyz (c1 c(5),i1 i)
>
>APPEND FROM test.txt DELIMITED
>
>BROWSE NOWAIT
>DELETE FILE test.txt
>
>start from that.
>
>It is also a bad idea to hard code a path
>
>lcFile = getfile()
>if !empty(lcFile) then
> APPEND FROM (lcFile) DELIMITED
>endif
>
>is absolute minimum.
>
>Lutz
>>Hi Lutz
>>
>>I have recreated my dbf and have manually imported the data into it
>>
>>I am now trying to import again by program
>>
>>use j:\global\awbshayes in 0 shared
>>select awbshayes
>>Append From j:\global\awbshayes.csv DELIMITED WITH "" WITH CHAR ,
>>
>>Nothing gets added and there are no errors
>>
>>What am I doing wrong
>>
>>Colin

Thanks for your help - I have fixed the bug in my VFP which stopped programs compiling properly

Colin
Specialist in Advertising, Marketing, especially Direct Marketing

I run courses in Business Management and Marketing
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform