![]() ![]() In this connection string we'll use the Jet 3.51 engine (although we could use Jet 4.0 instead) We'll use VBScript, but these same examples will work in pure VB as well.įirst, the connection string. Lets take a look at an example of how to connect to an Access database. The provider translates the complex details specific to the data source into the interfaces implemented by ADO so you can access the data generically, regardless of where it comes from. So, whether you are accessing a SQL database, an Access database, an Excel spreadsheet, or a CSV file, you will work with the data in the exact same way. The connection string tells ADO which provider to use and other details of where to find the data. ![]() One of the great things about ADO is that you work with all data, regardless of the source, in the same way. We'll look at three different examples using Access, Excel, and CSV files.įiogf49gjkf0d How to Connect to External Data Using ADO This article will focus on the aspect of accessing external data using ADO. Whether you're accessing data from SalesLogix, or from another data source, ADO is the technology you'll use inside of a SalesLogix VBScript. With SalesLogix v6, ADO is the new standard for accessing data. ![]() How to Connect to External Data Using ADO ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |