PeopleSoft Adoption Made Smooth & Simple!
On-The-Job Training Is made Intuitive & Easy With WalkMe's On-Screen Guidance Tool. Claim Your Free WalkMe Account Now
Function import(tableName As String) Dim strSQLDelete As String Dim strSQLImport As String Dim directoryName As String directoryName = "S:\ABCentre\ABDataC.mdb" strSQLDelete = "DELETE * FROM [" & tableName & "];" strSQLImport = "INSERT INTO " & tableName & " SELECT * From [" & directoryName & "].[" & tableName & "]" With DoCmd .SetWarnings False .RunSQL strSQLDelete .RunSQL strSQLImport .SetWarnings True End With End Function
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
|How to change safe sender list in Outlook for all O365 users and a specific domain?||3||47|
|SUBFORM on ACCESS 2013||8||37|
|MS Access Duplicate Data Assistance||9||33|
|max value in vbscript||7||19|
Join the community of 500,000 technology professionals and ask your questions.