Hi Guys,
How is everythig going??? I am stuck over here and your help is very much needed.
I am using the code below to connect to the sql server and import the tables. Its working fine. But the problem is it pops up with a window and ask me "to select a database".
Is there anyway I can overcome this. Because I am running a job overnight and there is no one here.
Tell me if I can do it in a better way.
Function transferData()
DoCmd.TransferDatabase acImport, "ODBC Database", _
"ODBC;SERVER=SERVER NAME;UID=UsER NAME;PWD=PASSWORD;LANGUAG E=us_english;" _
& "DATABASE=DATABASE NAME", acTable, "SOURCE TABLE NAME", "DESTINATION TABLE NAME"
End Function
Your help will be much appreciated.
Thanks guys
Dave
How is everythig going??? I am stuck over here and your help is very much needed.
I am using the code below to connect to the sql server and import the tables. Its working fine. But the problem is it pops up with a window and ask me "to select a database".
Is there anyway I can overcome this. Because I am running a job overnight and there is no one here.
Tell me if I can do it in a better way.
Function transferData()
DoCmd.TransferDatabase acImport, "ODBC Database", _
"ODBC;SERVER=SERVER NAME;UID=UsER NAME;PWD=PASSWORD;LANGUAG E=us_english;" _
& "DATABASE=DATABASE NAME", acTable, "SOURCE TABLE NAME", "DESTINATION TABLE NAME"
End Function
Your help will be much appreciated.
Thanks guys
Dave