Formula to find table to specific Drive 1

[rwn]

This SQL query needs to point to a drive path. Preivously it was written for an Access database and now it has been converted to a SQL database and the query needs to updated to reflect the SQL requirements. I'm not sure how to write the FROM `C:\Program Files\JobBOSS\jbudrpt`. I have rewritten the existing code to reflect SQL but am stuck on the From clause pointing to the C drive. The message is it can't find the table.

SELECT [Work Schedule - Promised Polishing Hrs per Work Week].W, [Work Schedule - Promised Polishing Hrs per Work Week].SumOfSumOfDifference
FROM `C:\Program Files\JobBOSS\jbudrpt`.[Work Schedule - Promised Polishing Hrs per Work Week] [Work Schedule - Promised Polishing Hrs per Work Week]
ORDER BY [Work Schedule - Promised Polishing Hrs per Work Week].W;

 

[dhookom]

I expect you should create a linked server in SQL Server. You might also be able to use OPENQUERY or OPENDATASOURCE. Check OPENDATASOURCE (Transact-SQL)

Duane
Hook'D on Access
MS Access MVP

 

[rwn]

Thanks Duane,

I was actually hoping to see an example of the coding to use vs an over view of the coding. Because, programming is not my expertise at all.

 

[PHV]

I'd post here:
forum183
or here
forum962

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886