Querying Excel with SQL

Guest · Oct 28, 2004

Is there a way to query an excel spreadsheet using SQL? I have used the
advanced filter but would like to be able to use SQL if possible.

Tom Ogilvy · Oct 28, 2004

Perhaps the methods suggested at Mr. Erlandsen's site:

http://www.erlandsendata.no/english/index.php?t=envbadac

Guest · Oct 28, 2004

Thanks,
Raul

Tom Ogilvy said:
Perhaps the methods suggested at Mr. Erlandsen's site:

http://www.erlandsendata.no/english/index.php?t=envbadac

Excel as front end and SQL Server as back end	0	Feb 19, 2010
What are the steps to fix damaged MDF files in SQL Server?	0	Mar 10, 2025
VBA error while using SQL "with rollup"	2	Jan 11, 2011
Using values in Excel as parameters in Microsoft Query connection	3	Dec 10, 2008
Using Query to return data from SQL database	3	Nov 24, 2008
Book about using VBA to run SQL queries with results put in Excel	3	Sep 13, 2008
Update Query from Excel VBA module	2	Oct 8, 2009
How pass credentials to Access from Excel (for onward use)	2	Apr 23, 2010

Ask a Question