Post reply

select * from tablename$

  • May 24, 2011 at 2:24 am

    #240163

    Hi,

    I have imported data from excel to SQL Server. SQL created a table named sheet1$ and now i can't make the select from it.

    It seems that i can not select from tables where name like $.

    Can you please help?

    Thank you

  • May 24, 2011 at 2:30 am

    #1328877

    river1 (5/24/2011)

    Hi,

    I have imported data from excel to SQL Server. SQL created a table named sheet1$ and now i can't make the select from it.

    It seems that i can not select from tables where name like $.

    Can you please help?

    Thank you

    try using square bracket [sheet1$]

    Muthukkumaran Kaliyamoorthy
    https://www.sqlserverblogforum.com/

  • May 24, 2011 at 11:01 am

    #1329257

    You could rename the table to something more useful.

    And next time you import from Excel, you get an opportunity in the wizard to give the table a proper name.

Viewing 3 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply