Why are my INTO not working?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Twice today I have run some SQL and it has created a cursor and not created a
table. I can not paste the SQL here because it is large and on another
machine.

One time there was a

a.[hello there] as column1 INTO

second time there was

a.[goodbye you] INTO

Both times I "fixed" it by moving a column name that did not have the []
directly before the INTO. This was not a problem previously. Any Ideas?

Brenda
 
Sorry, SELECT INTO.

And the "fix" of having a field that does not need the [] before the
INTO, no longer works. If I mixed the selected fields around, I always
get it to work. But I no longer see a pattern as to why it does not
work.

Access 2002 SP-2

Thanks

Brenda


[MVP] S.Clark said:
INSERT INTO or SELECT INTO?

--
Steve Clark, Access MVP
FMS, Inc.
www.fmsinc.com/consulting

Brenda said:
Twice today I have run some SQL and it has created a cursor and not created a
table. I can not paste the SQL here because it is large and on another
machine.

One time there was a

a.[hello there] as column1 INTO

second time there was

a.[goodbye you] INTO

Both times I "fixed" it by moving a column name that did not have the []
directly before the INTO. This was not a problem previously. Any Ideas?

Brenda
Click to expand...
Click to expand...
 
Back
Top