Phresh10
May 3rd, 2011, 03:53 AM
Hello
I will be very glad if somebody can kindly provide me with a sample code that will:
1. Connect MS Access to SQL Server via ADO,
2. After which data is extracted from i.e. Customer Database in SQL Server, and
3. Lastly, the data is then dumped onto MS Excel (“sheet1”).
Please you can assume an imaginary connection string i.e. Provider = AAA, Data Source = BBB, Initial Catalog = CCC.
From the little I know of ADO connection, there will be “command” and “recordset” in the code, please kindly provide brief comment as to purpose of “command” and “recordset” wherever they are used.
Regards
I will be very glad if somebody can kindly provide me with a sample code that will:
1. Connect MS Access to SQL Server via ADO,
2. After which data is extracted from i.e. Customer Database in SQL Server, and
3. Lastly, the data is then dumped onto MS Excel (“sheet1”).
Please you can assume an imaginary connection string i.e. Provider = AAA, Data Source = BBB, Initial Catalog = CCC.
From the little I know of ADO connection, there will be “command” and “recordset” in the code, please kindly provide brief comment as to purpose of “command” and “recordset” wherever they are used.
Regards