I am using the Insert database command several times in a visual basic macro. Every time I use the command in the macro the Select Data Source screen appears even though the source is set in the command as shown below. How do I prevent this screen from appearing?
Selection.Range .InsertDatabase LinkToSource:=T rue, _
Connection:="Pr ovider=SQLOLEDB .1;Integrated Security=SSPI;S erver=fccqt02;D atabase=Blue_So uth;",...
User Profile
Collapse
-
Lisa Coal started a topic Visual Basic InterDatabase command keeps displaying Select Data Source screenin SQL ServerVisual Basic InterDatabase command keeps displaying Select Data Source screen
No activity results to display
Show More