Export data from SQL Server table TO DBF file

Question

I want to convert SQL Server table data to .DBF file.

Below query is working without date. But when I add date it's not working. Please solve my issue, thanks in advance.

Without date:

INSERT INTO Fe130328.DBF (LINENO, BOOK, VCHSERIES, VCHNO, ACCODE, ACHEAD, CITY, NARRATION, DEBIT,CREDIT) 
VALUES ('" & str_sr_no & "','" & str_book & "','" & str_vchseries & "','" & str_vchno & "','" & str_accode & "','" & str_achead & "','" & str_city & "','" & str_narration & "','" & str_debit & "','" & str_credit & "')"

With date:

INSERT INTO Fe130328.DBF (LINENO, DATE, BOOK, VCHSERIES, VCHNO, ACCODE, ACHEAD, CITY, NARRATION, DEBIT, CREDIT) 
VALUES ('" & str_sr_no & "','21/07/2020','" & str_book & "','" & str_vchseries & "','" & str_vchno & "','" & str_accode & "','" & str_achead & "','" & str_city & "','" & str_narration & "','" & str_debit & "','" & str_credit & "')"

SQL Injection alert - you should NEVER EVER concatenate together your SQL statements - use parametrized queries instead to avoid SQL injection - check out Little Bobby Tables — marc_s
– marc_s, Commented Aug 1, 2020 at 5:20

Bheemsen Singh · Accepted Answer · 2020-08-01 07:58:20Z

1

Date value should be MM/DD/YYYY format. Just make change Date format and use following query.

INSERT INTO Fe130328.DBF (LINENO, DATE, BOOK, VCHSERIES, VCHNO, ACCODE, ACHEAD, CITY, NARRATION, DEBIT, CREDIT) 
VALUES ('" & str_sr_no & "','07/21/2020','" & str_book & "','" & str_vchseries & "','" & str_vchno & "','" & str_accode & "','" & str_achead & "','" & str_city & "','" & str_narration & "','" & str_debit & "','" & str_credit & "')"

answered Aug 1, 2020 at 7:58

Bheemsen Singh

1411 silver badge10 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Shailendra R Kumar Over a year ago

Thanks for reply, Error Msg. Syntax error in INSERT INTO statement.

Bheemsen Singh Over a year ago

It`s OK. but if you got help then you may upvote also.

Collectives™ on Stack Overflow

Export data from SQL Server table TO DBF file

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related