Combining records

  • Thread starter Thread starter MJ Ross
  • Start date Start date
M

MJ Ross

I have data exported to an xls then import it to a MS access v7 table that
looks like this:

Host_N IP Address Interface - Name OS Name
Server_03 192.168.1.110 Server_03.sx.company.com MS W2K3 R2
Server_03 192.168.1.123 Server_03-rib.sx.company.com MS W2K3 R2
Server_04 192.168.1.103 Server_04.sx.company.com MS W2K3 R2
Server_04 192.168.1.126 Server_04-rib.sx.company.com MS W2K3 R2
Server_04 192.168.1.105 portal.web.company.com MS W2K3 R2
Server_04 192.168.1.64 mysites.web.company.com MS W2K3 R2

Is there anyway I could create 1 record for the Host_name server then
combine say the multiple ip addresses for that server name into 1 field? Same
would be for Interface name too. I.E.

Server_04 192.168.1.103,192.168.1.126,192.168.1.105,192.168.1.64

I'm stumped.
 
Back
Top