I/O Redirection Q

[unkis17]

I am working on an access database I regularly update, specifically automating the updating part.

Right now I use TC with custom columns to copy and paste all files in a certain directory and then I dump them manually into a txt file using the copy details command. From there I tweak the text file in Excel so I can import it from XLS into the Access Database.

This is a lot of work to do when in the end I run a quick comparison query and all new files are kept. Is there a way in TC I can shorten this process?

The Columns I use are File name and Creation Date. The file format of the files are ["Title of Movie" (Release Year).iso]

Thank you,

Unkis

[ghisler(Author)]

Not automatically - have you thought about writing an Excel macro? You may even be able to write it directly to your database this way.

[unkis17]

That was a thought, but I don't know too much about VB, so I didn't persue it. I think you are right about the macro inside Excel or maybe even Access. Thank you