to Import or Not to Import which Front End do we use?

[DougP]

I Imported some Access tables using the SQL 2008 wippy dippy new Import/Export thingy and low and behold my tables don’t exist to it. Oh they show up in the explorer list and I can even open them up and view the data but can I write a simple Query? NOOOOOO.
Invalid Object!
So before I take this PC and throw it in the dumpster maybe some one could write me a script that the Microsoft SECURITY SQL GODS will tolerate my newly imported data.

here is my script if that matters.

SELECT Top 1 WeekStartDate, WeekEndDate, WeekNumber, PayPeriodDate, PayPeriod FROM [Timesheet PayPeriods] WHERE (WeekEndDate >= getdate())

Luckily I still have SQL 2000 and good ole Enterprise Manager so I can go in and just have fun and write code blind folded and guess what it works same database, same table. Just a different front end? Dooh!

TIA


DougP
< I Built one

http://www.robots2000.com

 

[DougP]

Oh now it magically works Today, I am using SQL server Express 2008 with SP1
Not sure why you can't add a tables, databases or whatever manually and then have to completely close SSMS for it to see your new objects? this is using the Query window, everything shows up as a red underline and it won't run.

DougP
< I Built one

http://www.robots2000.com