Connecting MS Access to SQL server via ADO, then extracting data from SQL Server and

[Phresh10]

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

[VictorN]

Don't you know MSDN exists?
FYI: MSDN = Microsoft Developer Network that contains and provides the documentation about languages, API, Interfaces, classes and so on to use for programming under Windows...

[noobi]

Phresh10
take a look at this link it helped me numerous times

http://www.connectionstrings.com/

Much Luck...