SQL Insert error
SQL Insert error
(OP)
I'm using the following code in SQL:
create table #temp1 (c1 int)
insert into #temp1 values (1)
insert into #temp1 values (2)
insert into #temp1 values (3)
insert into #temp1 values (4)
insert into #temp1 values (5)
insert into #temp1 values (6)
insert into #temp1 values (7)
I had it previously working in a different application.
Now, I've put it in a new application and I'm getting "Invalid object name '#temp1'". I'm doing this in VBA, using an ADODB connection and a corresponding recordset to create an sql call for each line in the input file.
I'm not sure why this isn't working as it was before. Any input is greatly appreciated.
create table #temp1 (c1 int)
insert into #temp1 values (1)
insert into #temp1 values (2)
insert into #temp1 values (3)
insert into #temp1 values (4)
insert into #temp1 values (5)
insert into #temp1 values (6)
insert into #temp1 values (7)
I had it previously working in a different application.
Now, I've put it in a new application and I'm getting "Invalid object name '#temp1'". I'm doing this in VBA, using an ADODB connection and a corresponding recordset to create an sql call for each line in the input file.
I'm not sure why this isn't working as it was before. Any input is greatly appreciated.
Talk To Other Members
RE: SQL Insert error
RE: SQL Insert error
You may need to send the statements on at a time
Good Luck
johnwm
________________________________________________________
To get the best from these forums read FAQ731-376 before posting
Steam Engine enthusiasts: www.essexsteam.co.uk