Creating Multiple ODBC System DSNs from an Excel Spreadsheet

  • Thread starter Thread starter Mark
  • Start date Start date
M

Mark

Have been searching Google for a solution, but don't see one. I see
several examples of code, none of which have successfully created a
System DSN from a command button in a spreadsheet that executes VBA
code.

I'd ultimately like to take a list of 30 project names and 30
corresponding mdb path+file names from an Excel spreadsheet, press a
button and create 30 DSN's.

If I can to work for one pair of project names and mdb files
(hardcoded), I think I know enough about VBA to hack my way into
reading the 30 pairs into the routine.

This is necessary because a vendor's program requires a System DNS to
access a mdb file. We have multiple projects on a network. Each of
about 35 members of my staff need to have all these DNS's setup on
their PC's.

Suggestions would be much appreciated (other than get another
application that doesn't require DNS's).

Thanks, Mark
 
Actually, it is not necessary to access database via DSN.
You can try to user UDL file to test the link and use it
in your code.

Best Regards

Bill
 
Back
Top