Linkk Workbk to data source

Y

Yossy

How do I create tables in Excel WkBook across multiple worksheet and connect
to a database source (MSSQL). From there I want to continously generate
update query monthly based on certain criteria(Queries).

Please I am a novice in this. Any step by step instruction will do. Or Link
to useful information as to get this done.

THanks
 

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

Link Excel Workbook to datasource 1
Copy charts and remove links to original source data 12
Problems with ACE OLEDB provider 1
populate some userform fields from access database 1
Populate userform fields from access database 1
Excel 2007 crashes after refreshing data linked to external source 0
Data Source will not pull Query 1
ADO connection Problems between excel worbooks 0

Top