MS Access - Importing

suarve · 27 Jan 2007 at 18:03

Hi,

I have a simple MS Access database that has a nice an simple Import routine, whereby an excel file is imported when the user clicks import. Would it be possible for me to someway log the path of the excel file that has been imported and record the windows user name that performed the import, in a simple report - E.g.

Date:
File:
User:

Thanks for any help.

suarve · 28 Jan 2007 at 15:45

No-one???

Mirage · 28 Jan 2007 at 17:51

Couldn't you just get the import button to fire off an insert query?

KevinCB · 29 Jan 2007 at 00:37

Doesn't your import routine get the path of the excel file?

As for the windows user name, I have a module to get that information, but I'll post it up later as I have it in a database at work.

As the previous poster mentioned, you're best inserting the information into a table, I can help you on the vba for this if you like.

Mirage · 29 Jan 2007 at 12:51

Here's the username Module I have:

Code:

Private Declare Function GetUserName Lib "advapi32.dll" _
Alias "GetUserNameA" (ByVal lpBuffer As String, nSize As Long) _
As Long

Function fncUserName() As String
    
    Dim Buffer As String * 100
    Dim BuffLen As Long
    BuffLen = 100
    GetUserName Buffer, BuffLen
    fncUserName = Left(Buffer, BuffLen - 1)
        
End Function

suarve · 29 Jan 2007 at 16:47

KevinCB said:
Doesn't your import routine get the path of the excel file?

As for the windows user name, I have a module to get that information, but I'll post it up later as I have it in a database at work.

As the previous poster mentioned, you're best inserting the information into a table, I can help you on the vba for this if you like.

That would be excellent, thanks. Hot me up on msn if you want: [email protected]

Thanks!