SQL and EXCEL

ZOCOR · Sep 9, 2004

Hi

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

ZOCOR

Tom Ogilvy · Sep 9, 2004

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

For sample connection strings you can see Able-Computing

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