When i import excel file to access using vba

Oleg

Registered User.
Local time
Today, 03:33
Joined
Jun 6, 2011
Messages
14
Where do i specify the TAB name ?

Code:
pathbgc = Path & "\ASIA - OMG Metrics " & CurrentDateText & " " & Month_Name_Long & " " & CurrentYear & ".xls"
DoCmd.TransferSpreadsheet acImport, , "Accuracy-Asia-Flow", pathbgc, vbYes
 

Users who are viewing this thread

Back
Top Bottom