SQL

So how exactly does Screen-Scraper write to an SQL or Access database?

SQL

TomRod,

screen-scraper itself does not do the inserting. Instead it is able to interact with an intermediary like ASP or PHP which then handles the database interactivity. Alternatively, we often will write the results out to either an XML file or a CSV file which can then be used to insert into a database.

Tutorial 5 walks you through interacting with PHP and how to prepare your scraped data for insertion into a database.

http://www.screen-scraper.com/support/tutorials/tutorial5/tutorial_overview.php

Here is a link to a general-use script that handles writing to a CSV file. This script is written in Interpretive Java.

http://www.screen-scraper.com/xfer/Write-to-file-template.txt

-Scott