470,616 Members | 2,460 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 470,616 developers. It's quick & easy.

Incorrect syntax near ','., Insert into parallel (, paycode, date, time) values (,'3'

There is an error in parallel.txt when I exporting attendance biometrics data as parallel into MSSSQL Server 2008R2.
Please help me how can I solve this.
Attached Images
File Type: jpg Parallel Logs.jpg (257.4 KB, 59 views)
Oct 24 '19 #1
1 2349
12,516 Expert Mod 8TB
You need to get rid of the initial commas in the field list and values list.
Oct 25 '19 #2

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

1 post views Thread by Amit D.Shinde | last post: by
4 posts views Thread by Carl | last post: by
11 posts views Thread by Mark Findlay | last post: by
1 post views Thread by Sandesh | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.