I have a linked server with Excel linked to SQL Server on my local system. I have six worksheets. Five of the six worksheets appear correctly in SQL Server with the correct number of records. One of the six only shows 999 records in SQL Server, but it should be 36,921.
What could cause this? Here is the meat of my stored procedure: Any advice would be appreciated. (Code Snippet attached).
@server = 'XLHybrid',
@provider = 'Microsoft.ACE.OLEDB.12.0',
@srvproduct = 'Excel',
@datasrc = 'C:\Database\XLHybrid.xlsm'