Import CSV into Sever 2003 DNS Active Directory Zone

You can import a list of items into your Microsoft Server 2003 DNS server’s Active Directory Zone. All you do is use Microsoft Excel to get your data straight, save it as a csv, open it in Notepad and replace all commas with spaces and then rename the csv file to .bat file. Then open an elevated command window on your DNS server and run the batch file.

DNSCMD DNSSEVERIPADDRESS /RecordAdd ZONENAME DEVICENAME RECORDTYPE IPADDRESS

You final code with look similar to the code below:

DNSCMD 10.10.10.5 /RecordAdd ocalawebsitehosting.com vps1 A 10.10.10.10
DNSCMD 10.10.10.5 /RecordAdd ocalawebsitehosting.com vps2 A 10.10.10.11
DNSCMD 10.10.10.5 /RecordAdd ocalawebsitehosting.com vps3 A 10.10.10.12