Exporting to SQL Server Via ODBC

[Mutanen Lau]

I want to export my dataset into sql server and got the following error message:

The ODBC driver reported the following diagnostics
[Microsoft][ODBC Driver 13 for SQL Server][SQL Server]Incorrect syntax near the keyword 'Table'.
SQLSTATE=42000

I set up the odbc driver correctly I even used

odbc load, table("DECILE 1 TO 6 IN NBR") dsn("NBR")

to import from the SQL SERVER, but when I used either

odbc insert, dsn("NBR") table("NEW DECILE  1 TO  6 NBR") create

Or

odbc insert, dsn("NBR") table("NEW DECILE  1 TO  6 NBR") insert

in trying to export to same SQL SERVER I got the above error.
please I need help.

Best Regards

[Joseph Coveney]

Please ask your DBA or developer to use rationale table names.

.ÿdiÿstrlen("DECILEÿ1ÿTOÿ6ÿINÿNBR")
20

.ÿdiÿstrlen("NEWÿDECILEÿÿ1ÿTOÿÿ6ÿNBR")
23

.ÿdiÿstrlen("NEWÿDECILEÿÿ1ÿTOÿÿ6ÿNBR")
23`