N
Nick
Matt,
You can do this either in Excel or in Access. I would
probably favour doing it in Excel prior to the import. In
a new column in excel enter =A1&"."&B1&"."&C1&"."&D1,
replacing the A1 to D1 cell references with the four
columns you require.
Hope this helps.
Nick
represent the four octets of an IP address. What I would
like to do is concatenate these four fields into one field
called IP Address. Can I do this in the import process?
If so, how? If not, can I do this within the table that I
import the data into? If that will not work, can I
concatenate them in a query? If I can, how would I do
that? Thanks in advance for your help. Matt
You can do this either in Excel or in Access. I would
probably favour doing it in Excel prior to the import. In
a new column in excel enter =A1&"."&B1&"."&C1&"."&D1,
replacing the A1 to D1 cell references with the four
columns you require.
Hope this helps.
Nick
are four fields called Octet1,Octet2... These fields
represent the four octets of an IP address. What I would
like to do is concatenate these four fields into one field
called IP Address. Can I do this in the import process?
If so, how? If not, can I do this within the table that I
import the data into? If that will not work, can I
concatenate them in a query? If I can, how would I do
that? Thanks in advance for your help. Matt