Lynn, I am sufficiently humbled. That looks exactly as it does in my VBA string (apart from the returned data has the whole string in the first column.

So, MsgDate...

Lynn, thanks for all the help. I'm getting the idea. As for splitting the field that contains "UTC" SQL does not know what to do with it,...

Lynn,

Clumn names are here for the working dbo_CDR table I'm using now.

[call_status]

,[channel_num]

,[sipcall_ident]

...

Lynn, I did not import the data, it is written to a table via a database connection from the syslog server, which is a table with 5 columns (since I'm...

I guess I'm in the wrong forum. The string is in a column. I have to split that srting into the necessary fields/data, and manipulate it so it...

The data is IN a table already. I got creative. The Mediant 2000 IP telephony gateway uses syslog to export the data. I used the KIWI syslog...

Thanks Lynn. The bulk insert works great AFTER I have processed the data. Here is an example of the CDR raw text data to give you an idea...