Transfer tables from SQL Server to MS Access

[dhar2611]

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

 

[genomon]

Why don't you just link the tables into Access?

The Microsoft mascot is a butterfly.
A butterfly is a bug.
Think about it....

 

[dhar2611]

I dont want to link table. B'coz it would slow the website and reduce the bandwidth.