| Home |
| Search |
| Today's Posts |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Changing data access from MSAccess2000 to SQL Server
Jason wrote: This is the code I am attempting to use for the SQL: myConn.Provider = "SQLOLEDB.1" myConn.ConnectionString= "DATABASE=glassPLC1;SERVER=yosql1;" Try changing DATABASE to INITIAL CATALOG. Jamie. -- |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How To Access Thru News Server | Excel Discussion (Misc queries) | |||
| Connect to Access Database On Remote Server | Excel Discussion (Misc queries) | |||
| Export from Access/SQL Server | Excel Discussion (Misc queries) | |||
| How do I access data stored in a SQL server for vlookup function? | Excel Worksheet Functions | |||
| ado connection to access vs. sql server? | Excel Programming | |||
Threaded Mode
