ExcelBanter - SQL and EXCEL

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - SQL and EXCEL (https://www.excelbanter.com/excel-programming/309448-sql-excel.html)

Hi

Stupid question: can you use excel as a database? if so, can you use sql to
access and analyse data in Excel?

ZOCOR

---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.737 / Virus Database: 491 - Release Date: 11/08/2004

HOWTO: Use ADO with Excel Data from Visual Basic or VBA
http://support.microsoft.com/default...b;en-us;257819

For sample connection strings you can see Able-Computing

http://www.able-consulting.com/tech.htm

--
Regards,
Tom Ogilvy

"ZOCOR" wrote in message
...
Hi

Stupid question: can you use excel as a database? if so, can you use sql
to
access and analyse data in Excel?

ZOCOR

---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.737 / Virus Database: 491 - Release Date: 11/08/2004