access director and file information via sql command

Is there a way to be able to perform select statements against a drives directories and files with out having import a text file of a dir >

Thanks
LVL 1
HalCHubAsked:
Who is Participating?
 
skullnobrainsConnect With a Mentor Commented:
you can run regular commands over the sql connection (dir, type, cat, ...)

http://technet.microsoft.com/en-us/library/aa260689%28v=sql.80%29.aspx

you should even be able to create a view based on xp_cmdshell that will let you actually use select queries and the likes but i assume you don't actually need that.
0
 
Gerwin Jansen, EE MVETopic Advisor Commented:
Windows directory and file information is stored in the Windows file system, to my knowledge you cannot run a SQL statement against that 'database'.

But scheduling a Windows task to create the text file that has all files and directories and importing that into a database may get you what you want.
0
 
Gerwin Jansen, EE MVETopic Advisor Commented:
@HalCHub - Does last comment above answer your question? Can you show for example how you 'select' all files with a .txt extension from a certain directory? That is what you were asking, right?
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.