Excel

[Gareth Barber]

I've created a Visual Basic Module which opens a conection to my database, and then lets me run sql queries. Does anybody know how to reference to an excel data cell from within the sql string?

[Ivo]

Hi, Gareth
I'm afraid you cannot reference excel data cell from sql string using normal sql language constructions. If you need to do this, you could try to create extended stored procedure to reference excel workbook,you can, of course do it from your Visual Basic code, using some controlword and parsing each query to replace controlwords with values from data cells.

Maybe will helpful to describe all your idea what you want to do exactly.
Ivo


------------
Gareth Barber at 8/20/01 7:16:06 AM

I've created a Visual Basic Module which opens a conection to my database, and then lets me run sql queries. Does anybody know how to reference to an excel data cell from within the sql string?