Its posible to insert data...

  • Thread starter Thread starter Guest
  • Start date Start date
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
 
.... just realized you are trying to export data, aren't you. In that case,
you'll have to use the vba method.

Seb
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

exporting the result of the SQL sentence(query) to excel 1
write all data from web import into single cell 5
Selecting point from chart while executing macro- is it posible? 3
Go back to update my data with my data entry sheet 4
Save As PDF / XPS 1
linking data from text file on ftp server to excel file 1
ADO-SQL-Excel 2
use validation on the userform of excel 3

Back
Top