SELECT INTO Error

[Tyork]

I keep getting an error everytime I try to execute the simplest 'select into' statement.

SELECT * INTO NewTbl
FROM (SELECT * FROM dbo_erc_CBC_GoodPhones)

results in:

"Cannot open databse''. It may not be a databsae that your application recognizes, or the file may be corrupt.

Running the simple select query without the 'select in' statement executes just fine. Any ideas?

[weekend00]

try to replace dbo_erc_CBC_GoodPhones with another table and run again.

[pbaldy]

Does this work?

SELECT * INTO NewTbl
FROM dbo_erc_CBC_GoodPhones

[Tyork]

Neither of those work. A similar query had executed within the last hour but for som reason select into will not work anymore.