Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 11-10-2020, 07:45 AM
wheddingsjr wheddingsjr is offline Can I write an SQL against an excel spreadsheet? Windows 7 64bit Can I write an SQL against an excel spreadsheet? Office 2016
Advanced Beginner
Can I write an SQL against an excel spreadsheet?
 
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
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
how to write reference into powerpoint graph from excel tab gulf2014 PowerPoint 0 10-18-2014 06:11 AM
write need help and copy write need help on another page auto wykoems Word 2 07-25-2013 07:56 AM
VBA code for count w and write into another column in excel tomlam Excel Programming 2 10-09-2012 03:56 AM
Can I write an SQL against an excel spreadsheet? count w and write into another column in excel tomlam Excel 5 10-07-2012 06:09 AM
Is it possible to write down a number starting with zero in excel cell? Rahmat_uk20 Excel 3 06-08-2012 02:26 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 03:49 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft