check this sql syntax?

Hi everyone,

Recently, I'm merge some excel table into one table by using ADO.NET, But was blocked by some sql sytax, Could you please help me table a look at following sql? Your help will be very appreciated!

I want to join Two tables (A, and B), the condition should be the number of A. columnA1 equal B.ColumnB1.

The data sample should be like below.

A.ColumnA1: "3052835 a is apple,"
B.ColumnB1: "3052835"

My intial thought should use Instr(A.ColumnA1, B.ColumnB1) >0. But seems that the condition should pass when B.ColumnB1 is 5 which is a part number of the A.ColumnA1(please refer to the sample above), I hope I can split the column of A.ColumnA1 with the space, and then I can compare A.ColumnA1 and B.ColumnB1. Who can tell me how to do it? Thanks a lot^-^

BTW, If the A.ColumnA1 include the string like "167/3052835 a is apple,", how to get the string of "3052835", I mean, How to get the string which between the "/" and space?

Thanks
Winnie

BTW, how to write sql for droping a sheet in Excel? (I want to do some operation on excel via ADO.Net, so i have to send some sql queries via ADO.Net)

I can use following sql to drop a sheet:
"drop table sheetname" it should works well

But it throw exception code hr=0x80040e14 when I want to add the condition of "if exists "

"drop table if exists sheetname" it throw exception

I think there should be something wrong with my second sql. right?


Thanks
Winniw