Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Importing a spreadsheet-like HTML file
Message
From
19/09/2006 10:44:25
 
 
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Visual FoxPro:
VFP 7 SP1
OS:
Windows XP SP2
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01155024
Message ID:
01155097
Views:
27
>Hi,
>
>>Thanks. Hmmm, seems bit of a faff to me.
>Not neccessarily.
>
>>This is (hopefully) a definitive style of input that one of our customers sends, that has to be converted to a VFP table. I don't know what .the "raised border" delimiter is in an HTML file.
>
>Should just be an attribute.

Not one of my areas of expertise/experience I'm afraid.

>
>>Guess I'll just have to save file as Excel then import that - easier :-)
>
>So this is something you need to do with a specific HTML page on a regular basis?
>If you can completely automate the process and end up with the VFP structure that you want then I guess using Excel is fine (assuming you know Excel is available). OTOH it's probably possible to build a parser to do the job in half an hour or so (but, of course, I haven't seen the HTML so....)

Cheers Viv

I know that excel is available as this is an in-house u/t for us to accept the customer's data, to do with bus ticket m/c data where that data is not stored electronically. In the past the data was sent as XLS or CSV - now they've suddenly changed it to HTML. I suspect that once converted to XLS I can reuse the code I've already written for such.

Terry
- Whoever said that women are the weaker sex never tried to wrest the bedclothes off one in the middle of the night
- Worry is the interest you pay, in advance, for a loan that you may never need to take out.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform