Excel Tools

Th new version for Import CSV to database is not working , when we provide input name  -Table  with a schema name , it is not working  ,So when checked the code , we found the issue  that it is not creating the query string properly . for Ex -- If the table reference is -- Schema.table name   ,it create the query string as insert into [schema.tableName] (column1,colum2) values (value1,value2)   but it should be  insert into [schema].[tableName] (column1,colum2) values (value1,value2) . If we provide the Input as schema].[tableName instead of schema.tableName it is working.

Th new version for Import CSV to database is not working , when we provide input name  -Table  with a schema name , it is not working  ,So when checked the code , we found the issue  that it is not creating the query string properly . for Ex -- If the table reference is -- Schema.table name   ,it create the query string as insert into [schema.tableName] (column1,colum2) values (value1,value2)   but it should be  insert into [schema].[tableName] (column1,colum2) values (value1,value2) . If we provide the Input as schema].[tableName instead of schema.tableName it is working.