SQL and EXCEL

[ZOCOR]

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]

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