Đã Hủy

WORD VBA Connection String to SQL database

I am migrating a WORD report project from connecting via querying a local MSAccess database to now using a local SQLServerExpress 2008 database.

So far my attempts to write the connection string to SQL and query the table have been unsuccessful

I need remote assistance to write the connection string, and set up a few queries

I want to schedule a time were meet meet via my WEBEX account so we can work together on the project

I need someone who is very experienced with VBA and SQL Server

Please bid for an hour's time and in the message let me know your additional hourly rate via freelancer

here is the old code that I used for the connection and query a table

'open the connection

db = appDirectory & "\[url removed, login to view]"

Set conn = New [url removed, login to view]

Set rs = New [url removed, login to view]

[url removed, login to view] "Provider=Microsoft.Jet.OLEDB.4.0;" & _

"Data Source=" & db

With rs

.Source = "Select * from TBLClients WHERE CLientID = '" & sClientID & "'"

.CursorLocation = adUseClient

.CursorType = adOpenStatic

.LockType = adLockReadOnly

.ActiveConnection = conn

.Open

Set rngFound = [url removed, login to view]("EvalDate").Range

[url removed, login to view] rs("assessdate")

Set rngFound = [url removed, login to view]("FName").Range

[url removed, login to view] rs("First Name")

Set rngFound = [url removed, login to view]("LName").Range

[url removed, login to view] rs("Last Name")

.Close

End With

Kỹ năng: SQL, Visual Basic

Xem thêm: word vba sql, word vba sql query, word vba database connection, vba word sql, word vba sql server, vba connection, vba word sql query, sql word vba, word vba connection string, word database sql, word vba database query, word vba connection, sql query word vba, sql vba word, vba sql word, word vba sql server connection, vba sql database connection, word vba sql connection, connection string word sql 2008, microsoft word vba sql connection, word vba query database, word vba sql server query, sql last word string, microsoft word vba connecting sql, vba word database connection

Về Bên Thuê:
( 117 nhận xét ) West Palm Beach, United States

Mã Dự Án: #1061913

13 freelancer đang chào giá trung bình $44 cho công việc này

schandraram

Hello - Please see PMB for details of my bid. Thank you. Chandra Ram

$35 USD trong 0 ngày
(85 Đánh Giá)
6.2
fedalal2

Hi, I have more 10 years experience with MS Access and SQL Server, so I'm realy GURU in this. I can help you with this project. Best Regards, Alex

$30 USD trong 1 ngày
(30 Đánh Giá)
5.4
srinichal

I can assist in the setup

$50 USD trong 2 ngày
(28 Đánh Giá)
5.2
koolsidz

Please see PMB

$45 USD trong 0 ngày
(34 Đánh Giá)
4.9
northwolves

I can help you.

$40 USD trong 1 ngày
(27 Đánh Giá)
4.5
DeoTech

Hi! Kindly see pm. Regards.

$30 USD trong 0 ngày
(5 Đánh Giá)
3.6
ProDarell

Hello. Please check the pm that I have sent you for some important details about this project. I'm a professional VB programmer and database developer.

$40 USD trong 1 ngày
(1 Đánh Giá)
2.2
MustafaShaheen

I have experience (10 years) in programming, so I can help you right now

$50 USD trong 2 ngày
(1 Đánh Giá)
1.4
eirikureiriksson

Details in PM

$75 USD trong 1 ngày
(0 Đánh Giá)
0.0
ShubhabrataKarma

I can do it.

$40 USD trong 2 ngày
(0 Đánh Giá)
0.0
rkrishnaprasadh

Dear Sir, Kindly refer to the Private Message for more details. Regards, R. Krishna Prasadh

$40 USD trong 0 ngày
(0 Đánh Giá)
0.0
mailtosivaz

hai this is [url removed, login to view] Skills:C#,VB6.0,asp.Net and SQL Server

$50 USD trong 1 ngày
(0 Đánh Giá)
0.0
AhmedEj

Dear, i am expert one in VBA,SQL Sever 2000/2005/2008. .NET and over 5 years experience in Application Development, and if you are interested kindly contact.

$45 USD trong 2 ngày
(0 Đánh Giá)
0.0