ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   populate a spreadsheet from SQL Server (https://www.excelbanter.com/excel-programming/338796-populate-spreadsheet-sql-server.html)

barnwood

populate a spreadsheet from SQL Server
 
I wish to populate a spreadsheet from a SQL server 2000 table. this needs to
be done whenever the workbook is opened and at regular instances. I'm being
lazy and looking for anyone who has already written code to do similar, thanks

NickHK

populate a spreadsheet from SQL Server
 
barnwood,
Data Get External Data New Database Query.

NickHK

"barnwood" wrote in message
...
I wish to populate a spreadsheet from a SQL server 2000 table. this needs

to
be done whenever the workbook is opened and at regular instances. I'm

being
lazy and looking for anyone who has already written code to do similar,

thanks




All times are GMT +1. The time now is 08:25 AM.

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