On Thu, 12 Nov 2009 09:24:01 -0800, MJ Ross
<(E-Mail Removed)> wrote:
Here is one approach:
http://www.mvps.org/access/modules/mdl0004.htm
-Tom.
Microsoft Access MVP
>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.
Similar Threads
