include file from network server

A

anna

I have a word macro that pulls data from a database server. I need to have
the ADO "connection string" stored in a file on a shared drive on the
network.

F:\constr.txt would have this statement in it:

Const ConnStr = "Driver={SQL
Server};Server=xxxxx;Database=xxxx;UID=guest;PWD=guestpass"

How do I access this connection string from my macro on a client machine?
 
W

Word Heretic

G'day "anna" <[email protected]>,

Open MyFilename for Input as #1



Steve Hudson - Word Heretic

steve from wordheretic.com (Email replies require payment)
Without prejudice


anna reckoned:
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Unable to update/add records in connected SQL Server tables 4
runtime error "-2147217843 on SQL server connection 2
problem writing an Excel file on server using Microsoft.ACE.OLEDB. 1
Access Pass-through Query to SQL Server 7
Connection String to SQL Server in VBA 3
VBA Excel data to SQL Sever table 1
Oracle Connection String 1
Excel as front end and SQL Server as back end 0

Top