I have opened up the Categories table in Northwind db(SQL2k5) and copied the contents of that table into an Excel worksheet.
I have saved the file as Northwind.xls
Conceptually I know what it is that needs to be done (i think). After a few hours now I still haven't got it.
Any ideas or examples would be much appreciated. Thanks!
If you are going to read data using the DDT object, you can find an example in the "Using DDT Drivers" Help topic. To see JScript code in the topic, please use the filter icon at the top left corner of the topic header.
If you are going to use the ADO object, please see the "Connecting to a Microsoft SQL Server Database Using ADO. Example" Help topic.