MS Access Functions
I am writing an application to import a series of Excel spreadsheets into Access (2003) and need some file access functions. I found the following which works fine.
Declare Function adh_accOfficeGetFileName Lib "msaccess.exe" _
Alias "#56" (gfni As adh_accOfficeGetFileNameInfo, ByVal fOpen As Integer) As Long
In the same place I found the following, which doesn't work:
Declare Sub adh_accSplitPath Lib "msaccess.exe" Alias "#59" _
(ByVal strPath As String, ByVal strDrive As String, _
ByVal strDir As String, ByVal strFName As String, ByVal strExt As String)
(I have omitted the rest of the code to keep it simple)
When I execute the adh_accSplitPath subroutine it complains that it can't find entry point #59. The code was intended for Access 97 and I am using Access 2003, so I assume the library has changed.
Where can I find a list of these functions for Access 2003?
Does anyone know the alias for this function in Access 2003?
Is there a more portable way of doing it?