<div>
is the table name company$item.No. ? <br />
If it is, then enclose it in brackets, e.g. select * from [dbo].[company$item.No.] the dot in the name is misinterpreted
</div>


is the table name company$item.No. ?
If it is, then enclose it in brackets, e.g. select * from [dbo].[company$item.No.] the dot in the name is misinterpreted

<div>
The exact table name is dbo.company$item &nbsp;and the column is No.
</div>


The exact table name is dbo.company$item  and the column is No.

<div>
<div class="content wysiwyg-content">
I can see this table from QA &amp;&nbsp;EM? &nbsp;Why will it not allow me to INSERT INTO?
</div>
</div>


I can see this table from QA & EM?  Why will it not allow me to INSERT INTO?

T-SQL error Invalid object name 'dbo.company$Item.No.'.

Databases are organized collections of data, most commonly accessed through management systems including schemas, tables, queries and processes that allow users to enter and manipulate the information or utilize it in other fashions, such as with web applications or for reporting purposes.