ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Loading SQL Data into Excel 2003 with VBA (https://www.excelbanter.com/excel-programming/377009-loading-sql-data-into-excel-2003-vba.html)

CharliePgmr

Loading SQL Data into Excel 2003 with VBA
 
I need to load rows from a SQL Table into an Excel spreadsheet. Does anyone
have a code sample they can pass on.
Thanks in Advance
Charlie

Jim Thomlinson

Loading SQL Data into Excel 2003 with VBA
 
Give this site a quick look. It will get you going on using ADO to query a
database...

http://www.erlandsendata.no/english/...php?t=envbadac
--
HTH...

Jim Thomlinson


"CharliePgmr" wrote:

I need to load rows from a SQL Table into an Excel spreadsheet. Does anyone
have a code sample they can pass on.
Thanks in Advance
Charlie



All times are GMT +1. The time now is 09:42 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com