Thread: Changing DSN programmatically?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.querydao,microsoft.public.excel.programming
Jamie Collins Jamie Collins is offline
external usenet poster
  
Posts: 593
Default Changing DSN programmatically?
(Michael Bourgon) wrote ...

I have a bunch of XL spreadsheets that all query the same DSN, a
FoxPro database. I want to move them to our SQL Server copy of those
databases.
Is there any way to automatically update the DSN?

I think you'd need to use the odbc API to do this. See:

http://msdn.microsoft.com/library/de...itefiledsn.asp

Jamie.

--
Reply With QuoteReply With Quote