Select Distinct To Populate Combo Box

error#9 · Jan 16th 2007

Re: Select Distinct To Populate Combo Box

I see what you mean.

Just one thing, is it possible to do this in a work book that does not yet exist.
As the workbook i'm in is not to be used.

can you use something like this:

Code

CommandText = "SELECT* into [Excel 8.0;Database=C:\\Book1.xls

or something?

gollem · Jan 16th 2007

Re: Select Distinct To Populate Combo Box

Hi,

yes this is possible, you better search the net for this.

I've used this a long time ago and I want to make a remark: If it's a lot af data that has to be written the application can slow down.

error#9 · Jan 16th 2007

Re: Select Distinct To Populate Combo Box

Most it will be is a few hundred lines if that.

Thanks ever so much for your help

Participate now!