Find file type i.e txt, xls in Access 97

[ian_w]

Hi,

I am writing a file cataloge program that searchs a chosen drive and places all the data in a table.

Im trying to get find a way that I can pull the actual filetype.

Is there a way to do this in access 97? Im using the Application.Filesearch tool to do this, i've tried the .FileType but that seems to be a search parameter rather than a information retriever.

I have found a couple of things while searching the forum but nothing that seems possible in 97?

Thanks

Ian

 

[gemma-the-husky]

try the dir command.

i think a lot of people use this in all versions anyway, as it is forwards compatible, and completely reliable

 

[tehNellie]

FileSystemobject is also an option

 

[namliam]

To reliably find what type of file it is you will have to go to the registry I think...

Tho that works mostly with extensions...
.xls = Excel
.txt = Text
Etc.