View Single Post
 
Old 11-10-2020, 07:45 AM
wheddingsjr wheddingsjr is offline Windows 7 64bit Office 2016
Advanced Beginner
 
Join Date: Mar 2017
Posts: 76
wheddingsjr is on a distinguished road
Default Can I write an SQL against an excel spreadsheet?

Hi all

I have searched google for an answer to this question and I found a source, however, it doesn't seem to make sense to me. here is the code i used based on how I interpreted the source I found:

Code:
<select * from [\\Cifs2\pop_lab$\P4P\Automation\2_EOL_Claims_ForDashboard\Past Claims and Cohort\BCBSMA\FY19\BCBSMA_FY19_Received_Claims.xlsx$]>
But I get this error message:

Code:
Msg 208, Level 16, State 1, Line 1
Invalid object name '\\Cifs2\pop_lab$\P4P\Automation\2_EOL_Claims_ForDashboard\Past Claims and Cohort\BCBSMA\FY19\BCBSMA_FY19_Received_Claims.xlsx$'.
Does anyone have any idea why this isn't working?
Reply With Quote