Parse a path for a file name in Access

[CK]

Hi All,
How do I parse a file path in Access for return the file name?
Example
c:\somefolder\somefolder\somefolder\somefolder\somefolder\somefolder\somefolder\someFile.xls
I want to query a table with this value and just return 'someFile.xls" no
matter how long or short the path is. I can do this in SQL Server, but i am
new to Access SQL and I can not figure it quite out.
Any help is always appreciated.

Cheers,
~ck

 

[Bob Quintal]

Hi All,
How do I parse a file path in Access for return the file name?
Example
c:\somefolder\somefolder\somefolder\somefolder\somefolder

\somefolde> r\somefolder\someFile.xls

I want to query a table with this value

and just return 'someFile.xls" no matter how long or short the
path is. I can do this in SQL Server, but i am new to Access SQL
and I can not figure it quite out. Any help is always appreciated.

Cheers,
~ck

The VB dir() function has a useful feature in that if you pass the
fully qualified path+file name, it will return the file name without
the path.