Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Append from text file into memo fields
Message
General information
Forum:
Visual FoxPro
Category:
Other
Miscellaneous
Thread ID:
00908998
Message ID:
00909012
Views:
17
Don't waste your time trying to append from the csv. Look in the help file for FGETS. Parse the file and insert the data or append the data from variables.
		lnfile=Fopen([C:\Spillman\FoxData\]+lcTable+[.txt])
		If lnfile < 0
			Messagebox("Error opening file!")
		Else

			Do While Not Feof(lnfile)
				lcLine = Fgets(lnfile,700)
				lnOccur= Occurs('|',lcLine)

				lnPipe1 = At('|', lcLine , 1)
				lnPipe2 = At('|', lcLine , 2)
				lnPipe3 = At('|', lcLine , 3)
				lnPipe4 = At('|', lcLine , 4)
				lnPipe5 = At('|', lcLine , 5)
				lnPipe6 = At('|', lcLine , 6)
				lnPipe7 = At('|', lcLine , 7)
				lnPipe8 = At('|', lcLine , 8)
				lnPipe9 = At('|', lcLine , 9)
				lnPipe10 = At('|', lcLine , 10)
				lnPipe11 = At('|', lcLine , 11)
				lnPipe12 = At('|', lcLine , 12)
				lnPipe13 = At('|', lcLine , 13)
				lnPipe14 = At('|', lcLine , 14)
				lnPipe15 = At('|', lcLine , 15)

                         *insert or append to your table here
                 endif
James Harvey, MCP
Memphis Police Department
225 Channel Three DR
Memphis, TN 38103
901 577-1296
Previous
Reply
Map
View

Click here to load this message in the networking platform