Access 2003 VBA query to SQL 2000 database

[Webkins]

I am trying to use Access 2003 VBA on a local PC to execute a query on a remote server running SQL 2000. Here is the VBA query I am trying to use with no luck:

"SQLa INSERT INTO tbl_Data IN '" & Path & "' SELECT * FROM Oven_Data"
Set rs = cn.Execute(SQLa, , adCmdText)

tbl_Data is in Access 2003 on my PC I want to populate
Oven_Data is in SQL 2000 on the server which contains the data.
Path is the path to the database on my local PC

I am not having luck in making this happen. Any suggestions ? Thank you all so much in advance.

 

[bborissov]

That is more Access question than SQL Server one
Ask in Access form.

Borislav Borissov
VFP9 SP2, SQL Server 2000,2005 & 2008.