Not that it should matter.. the 2nd value in the csv is an IP address.. its in the file as 192.168.7.25(just an example), but gets read as 192.1687, if the file is setup as delimited in the connection string, does that have any restraints on the data being read?
When i open the file in notepad, the comma is at the end of the IP address, when i open it in excel it is in its own column.. so what could be causing this?
Because of this issue with the truncation, that is what is causing the primary key issue.. because there are other values that are similar like these:
because if the issue, it passes each one of those as 192.1687
Here is the table structure, in case it helps resolve this issue..
[id] [int] NOT NULL,
[IpAddress] [varchar](16) NOT NULL,
[MacAddress] [varchar](16) NULL,
[APTypeId] [int] NOT NULL,
[APUser] [varchar](256) NULL,
[APPass] [varchar](128) NULL,
[APLocation] [varchar](20) NULL,
[APFreq] [varchar](50) NOT NULL,
[APBand] [varchar](50) NOT NULL,
View Complete Post