In Office 2010 I want from Excel make query in Access

€8-30 EUR

Completed

Posted

over 5 years ago

€8-30 EUR

Paid on delivery

Need little help with coding In Office 2010 I want from Excel make query in Access. The accd is already open. In Excel I code: Public Function GetCollOntvInBoho(Dosnr) As Collection Dim AccessApp As Object, SqlBoho As String, rsBoho As Object, Coll As New Collection Set AccessApp = GetObject("X:\[login to view URL]").Application If Not AccessApp Is Nothing Then SqlBoho = "SELECT * FROM tblBoho WHERE Dosnr = " & Dosnr & " AND Grootboekrekening = 1013 AND Activa > 0" Set rsBoho = [login to view URL](SqlBoho) etc I get an error at line: Set rsBoho = [login to view URL](SqlBoho), saying kind of: This property is not supported with this object. I give you € 20 for the answer. Thanks in advance.

Excel

Microsoft Access

Project ID: 17384924

About the project

17 proposals

Remote project

Active 6 yrs ago

Looking to make some money?

Email address

Benefits of bidding on Freelancer

Set your budget and timeframe

Get paid for your work

Outline your proposal

It's free to sign up and bid on jobs

Awarded to:

@archanaoswal

I know how to make a query to Access DB using Excel VBA I have excellent command on MS Excel. I have completed complex projects in Excel before. For instance - Create a schedule for delivery trucks pick-up and drop for optimal utilization of resources based on various constraints - Get match details, odds and stats of tennis matches and place bet automatically on betfair (API), pinnacle (API) and tennisinsight (scraping) websites. - Buy and sell bitcoins on Coinfloor and GDAX using respective APIs. - Built a POS and inventory management system. - Built a hotel price comparison that pulls data using the website's API. You can see the reviews of the same in my profile. Thanks, Archana

€20 EUR in 1 day

4.9

(55 reviews)

5.4

17 freelancers are bidding on average €26 EUR for this job

@schoudhary1553

Hi there, Warm Greetings We came along with your request for from Excel make query in Access and we reviewed your project description. We'd like to help you with confidence and satisfying results. We have professionals working here with 100% results and more creative and renovative ideas for our clients ! We have worked on several similar projects before! We are offering our services for more than 5 years in the field of Excel, Microsoft Access We have worked on 350+ Projects. Please check the profile reviews Feel free to message us to discuss briefly about your project !

€31 EUR in 1 day

5.0

(254 reviews)

7.5

@VladimirLilenko

Hello, dear sir! I registered at the forum not so long ago, but I already have several completed projects on www.freelancer.com. I am ready to carry out your project in the reasonable price and in the shortest possible time and with the highest quality! From the Access, of course, familiar. Give me a chance to show what I can do!

€20 EUR in 0 day

4.9

(93 reviews)

6.0

@vmadhavan15

share the screen via teamviewer I will fix it.. I can do this one on directly accessing your system.. Please ping me if you are interested iwth my proposal.. thank you..

€30 EUR in 1 day

4.9

(17 reviews)

4.6

@graphicdoll

Hi, I have Read Your Project Excel . I am very Interested in your Project and also I am ready to Start Immediately. I assure you will like my Work very much and I will deliver you project timely and there will be no Delay in my Work. I will start work ASAP. I am here for long term work Relationship. So will give you 101% best output from my end, So that you consider me for Future Job. Thanks and Regards, Inderjeet

€74 EUR in 1 day

4.5

(3 reviews)

3.4

@Maheshpatel107

Hello, I have read your problem related to access query in excel macro. I am able to help you in given problem and will solve this quickly. I have 5 years experience of software development.. Thanks Mahesh

€20 EUR in 1 day