>i have downloaded an HTML file which i need to import into a table.
>
>when i see it in Notepad++ it shows up very clearly with a total of 27614 lines
>
>however when i import it into my table
>
>
>
>append from 1.htm type sdf
>
>
>
>everything is double spaced and the number of lines doubles also

The HTML file probably isn't ASCII, it's probably encoded as UTF-8 or maybe Unicode.

You can convert it to something VFP can import:

lcMemVar = FILETOSTR( "MyHTMLFile.html" )
lcASCIIMemVar = STRCONV( lcMemVar, {flags} )
* You'll have to experiment with {flags}
* If it's UTF-8 you may have to first convert from UTF-8 to double byte (11),
* then double-byte to single-byte (2)

* Write it back out to an ASCII file:
=STRTOFILE( lcASCIIMemVar, "MyASCIIFileName.txt" )

* Then do your APPEND