| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
sql server connection
Can you get to the database using MsQuery? If you can then record a macro
whilst doing so. Within that macro you will get the syntax you need. -- Regards Andy Wiggins www.BygSoftware.com Home of "Save and BackUp", "The Excel Auditor" and "Byg Tools for VBA" "kanan" wrote in message ... hi, I would appreciate if somebody can give me the exact syntax for connectiing to a sql server 7.0 with windows 2000 authentication. my sql server is XXSQL1 and database name is XYZ. Iam getting syntax error with various combinations. thanks Kanan |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| always recheck data connection library for latest connection strin | Excel Discussion (Misc queries) | |||
| SQL Server -- Bulk Insert from Excel to SQL Server | Excel Discussion (Misc queries) | |||
| no DDE connection?? | Excel Discussion (Misc queries) | |||
| Excel 2003 Error Cannot Locate the Internet Server or Proxy Server | Excel Discussion (Misc queries) | |||
| problem updating link from Novell server to windows server #REF er | Excel Discussion (Misc queries) | |||
![Andy Wiggins[_3_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
