Your technology certification is waiting. Enroll in Cloud Class ®
Watch this video to see how easy it is to make mass changes to Active Directory from an external text file without using complicated scripts.
DoCmd.TransferText acImportDelim, "BB_FORMAT Import Specification", "BB_FORMAT", "C:\Temp\ExpertsExchange\Salary 2009_04.txt", False
Open in new window
Private Sub cmdImportData_Click()
Dim fldFileDialog As FileDialog
Set fldFileDialog = FileDialog(msoFileDialogOpen)
.ButtonName = "Import"
.InitialView = msoFileDialogViewDetails
.Title = "Select file to import"
.AllowMultiSelect = False
.Filters.Add "Text files", "*.txt"
If .Show Then ' File selected
DoCmd.TransferText acImportDelim, "BB_FORMAT Import Specification", "BB_FORMAT", .SelectedItems(1), False
Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.
Have a better answer? Share it in a comment.
Please enter a first name
Please enter a last name
Must be at least 4 characters long.
Join and Comment
If managing Active Directory using Windows Powershell® is making you feel like you stepped back in time, you are not alone. For nearly 20 years, AD admins around the world have used one tool for day-to-day AD management: Hyena. Discover why.