<div>
Pat is right. I wonder how you imagine the SQL Server should be able to &quot;see&quot; your linked sheet as the purpose of a pass-through query is to run code on the server.<br />
<br />
So use a pass-through query to create your empty table on the server, then run a normal append query to fill it from your linked sheet.<br />
<br />
/gustav
</div>


<div>
<div class="content wysiwyg-content">
I am trying to create a table in a linked SQL Server 2016 database from a linked Excel 2013 file in MS Access. I cannot get the pass-through query to work. Any help would be appreciated.<br />
<br />
Using query designed to create pass-through query where tblSheet1 is the excel and tbl1 is the table I am trying to create in SQLServer: <br />
SELECT tblSheet1.VENDOR_NUMBER <br />
INTO tbl1<br />
FROM tblSheet1<br />
<br />
Throw error:<br />
ODBC-- Call Failed<br />
[Microsoft][SQL Server Native Client 11.0][SQL Server]Invalid object name 'tbleSheet1'. (#208)
</div>
</div>


I am trying to create a table in a linked SQL Server 2016 database from a linked Excel 2013 file in MS Access. I cannot get the pass-through query to work. Any help would be appreciated.

Using query designed to create pass-through query where tblSheet1 is the excel and tbl1 is the table I am trying to create in SQLServer: 
SELECT tblSheet1.VENDOR_NUMBER 
INTO tbl1
FROM tblSheet1

Throw error:
ODBC-- Call Failed
[Microsoft][SQL Server Native Client 11.0][SQL Server]Invalid object name 'tbleSheet1'. (#208)

Excel linked to Access linked to SQL Server

SQL (Structured Query Language) is designed to be used in conjunction with relational database products as of a means of working with sets of data. SQL consists of data definition, data manipulation, and procedural elements. Its scope includes data insert, query, update and delete, schema creation and modification, and data access control.

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.

Microsoft SQL Server

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.