to sql from excel? not using DTS

Hi,

You can use the External Data feature of Excel:
- menu Data Import (or Get) External Data New Database Query
- in the dilaog, choose a data source or data source type
- then follow the dialog steps and build your query

or in VBA you can use ADO:
- Add the Microsoft ActiveX Data Object library throu the Tools referwences
menu of the VB Editor

I hope this helps,
Sebastien

"Ricardo Guzmán" wrote:

to sql from excel? not using DTS

.... just realized you are trying to export data, aren't you. In that case,
you'll have to use the vba method.

Seb

"Ricardo Guzmán" wrote:

to sql from excel? not using DTS