Does anyone know where I can download television episode guides converted to Microsoft Access format?

August 9, 2006 3:20 PM

Does anyone know where I can download television episode guides converted to Microsoft Access format?

I've tried reformating these ...

http://epguides.com/BuffytheVampireSlayer/

... but I can't get the column cut-offs to work properly...

posted by feelinglistless to Media & Arts (4 answers total)

Best answer: Copy and paste them into Excel first. They'll all be in one column, so use the Data>Text to Columns wizard and adjust the column widths appropriately. Now you can Import them into Access from the Excel spreadsheet.
posted by jasper411 at 3:23 PM on August 9, 2006

Response by poster: Thanks very much. That's perfect.
posted by feelinglistless at 3:47 PM on August 9, 2006

StateTheObviousFilter: There are much better Buffy episode guides than that, if it's primarily Buffy you're interested in.
posted by AmbroseChapel at 7:16 PM on August 9, 2006

Response by poster: Well I know, but it's for a cataloguing project and I needed a way to pull the data into something without having to type it all in...
posted by feelinglistless at 3:21 PM on August 10, 2006