Export data to table in the Schema of Sql server using VBA

I want to create table and insert excel data inside the defined schema in sql server. Currently , i am using following code, which create table in dbo schema in sql server but i want that code should create table in schema name 'RTI'.

Please Login or Register  to view this content.

Need code for creating table inside the defined schema.

Thanks & Regards
Ramandeep Singh

Hi xlnitwit,

I already this. but it will not work.

Thanks & Regards
Ramandeep Singh

Anyone knows the answer...

Any expert who can help me