Logging solutinos at DVinfo.net

Jennie Stenhouse · February 12th, 2008, 02:43 PM

Right so I have a problem that some one out there may be able to help me with. I am trying to figure out a better way to deal with the logging of tapes we are currently stuck with a HUGE word file that has tables. Its horrible to work with.. not really searchable in the right way and a pain to update with over three hundred tapes in it needs some sort of revamp.

basically the searchablity of it is really really important
this is just the text version of the log

any suggestions or help would be greatly appreciated.

cheers!!

Jennie

Tony Neal · February 12th, 2008, 02:57 PM

If the text is in a table in MS Word, then you should be able to cut and paste it straight into an Excel spreadsheet. Once in Excel, you can sort the rows by whichever columns you want, making it much easier to find stuff, and you can still do text searches.

You could then import the spreadsheet into an MS Access database and design some forms for querying and entering data, but this takes a bit more time and expertise.

Jennie Stenhouse · February 13th, 2008, 06:53 AM

Hi ya

the thoughts of a database had actually crossed my mind already ( my background is comp sci oddly enough ) I thought there might already be a solution on market but i guess rolling my own really is going to have to be the way to go !

Cheers

Jennie

February 12th, 2008, 02:43 PM	#1
Jennie Stenhouse Regular Crew Join Date: Aug 2007 Location: SOUTH AFRICA Posts: 40	Logging solutinos Right so I have a problem that some one out there may be able to help me with. I am trying to figure out a better way to deal with the logging of tapes we are currently stuck with a HUGE word file that has tables. Its horrible to work with.. not really searchable in the right way and a pain to update with over three hundred tapes in it needs some sort of revamp. basically the searchablity of it is really really important this is just the text version of the log any suggestions or help would be greatly appreciated. cheers!! Jennie

February 12th, 2008, 02:57 PM	#2
Tony Neal Regular Crew Join Date: Jun 2007 Location: Fareham, UK Posts: 160	If the text is in a table in MS Word, then you should be able to cut and paste it straight into an Excel spreadsheet. Once in Excel, you can sort the rows by whichever columns you want, making it much easier to find stuff, and you can still do text searches. You could then import the spreadsheet into an MS Access database and design some forms for querying and entering data, but this takes a bit more time and expertise.

February 13th, 2008, 06:53 AM	#3
Jennie Stenhouse Regular Crew Join Date: Aug 2007 Location: SOUTH AFRICA Posts: 40	Hi ya the thoughts of a database had actually crossed my mind already ( my background is comp sci oddly enough ) I thought there might already be a solution on market but i guess rolling my own really is going to have to be the way to go ! Cheers Jennie