MS Acess 2013 for HTTP Get and Post

I am busy with development that link my MS Access 2013 database to GET data from the SQL Server as well as POST data to the SQL Server.
I am aware of the 'HTTP Get' and 'HTTP Post' functions and would like to know where I can get reading material on these two functions that explains all the parameters for MS Access specifically. Also some logical diagrams that show data flow.
Any help is appreciated. . . . .
Anton GreffrathAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Gustav BrockCIOCommented:
SQL Server is not a web server.

In Access, go to External Data and select ODBC database. Set up a connection to the server and link/attach the tables/views you need. Lots of tutorials on this for the browsing.

/gustav
0
Eric ShermanAccountant/DeveloperCommented:
I use Pass-Through Queries with Access and SQL Server.  You can Link the tables as gustav posted or you can include the Connection String in the query Property "ODBC Connect Str"  as shown below...

ODBC;Driver={SQL Server};Server=xxx.xx.xxx.x;Database=YourDBName;User=YourUserName;Password=YourPassword;

Open in new window


Then, just run your queries in your Access front-end.

ET
0
Anton GreffrathAuthor Commented:
Thanks Gustav and Etsherman. . . . . . .

Apologies, I did not give you the full picture. The SQL Server export the data do a folder and I need to 'Get' the data from this position, external to the SLQ Database.
0
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

Eric ShermanAccountant/DeveloperCommented:
<<<<<Apologies, I did not give you the full picture. The SQL Server export the data do a folder and I need to 'Get' the data from this position, external to the SLQ Database. >>>>>

What format is the data in that you want to import into Access???

ET
0
Gustav BrockCIOCommented:
And how can get to that file? Is it on a file server you have access to, or is it hosted by a web or ftp server?

/gustav
0
Anton GreffrathAuthor Commented:
Gustav

The file is in CSV format as supplied  from the SQL Database. I have access to the file location via:
http://cosmo.co.au/CSV/GetClients, where GetClients is the CSV File
0
Gustav BrockCIOCommented:
Then the simple method is to download the file to a folder your application has access to and import it from there.

To retrieve the file, use a function like this:
Option Compare Database
Option Explicit

Private Declare Function URLDownloadToFile Lib "urlmon" Alias "URLDownloadToFileA" ( _
    ByVal pCaller As Long, _
    ByVal szURL As String, _
    ByVal szFileName As String, _
    ByVal dwReserved As Long, _
    ByVal lpfnCB As Long) _
    As Long


Public Function DownloadFile( _
    ByVal strURL As String, _
    ByVal strLocalFilename As String) _
    As Long
  
' Download file or page with public access from the web.
' 2004-12-17. Cactus Data ApS, CPH.

' Usage, download a file:
' lngRet = DownloadFile("http://www.databaseadvisors.com/Graphics/conf2002/2002ConferencePicsbySmolin/images/dba02smolin27.jpg", "c:\happybassett.jpg")
'
' Usage, download a page:
' lngRet = DownloadFile("http://www.databaseadvisors.com/conf2002/conf200202.asp", "c:\dbaconference.htm")

' Returns 0 if success, error code if not.
' Error codes:
' -2146697210 "file not found".
' -2146697211 "domain not found".

' Limitation.
' Does not check if local file was created successfully.

    Dim lngRetVal As Long
      
    lngRetVal = URLDownloadToFile(0, strURL & vbNullChar, strLocalFilename & vbNullChar, 0, 0)
    
    DownloadFile = lngRetVal
  
End Function

Open in new window

/gustav
0
Eric ShermanAccountant/DeveloperCommented:
<<<<<The file is in CSV format as supplied  from the SQL Database.>>>>>

Download the file ... Then use the Import Wizard in Access to import a Text file as shown below.  You can click the Advanced button and create an Import Spec for your file.

ET

Import Text
0
Anton GreffrathAuthor Commented:
Thanks Gustav and Etsherman, great answer and quick response! I have implemented your suggestions and it works like a dream.

I still require some reading material on the subject, do you perhaps have a link to such material? it was nice implementing the solution but I would like to have an understanding of the subject. . . .

Many thanks again

PetranAnton
0
Anton GreffrathAuthor Commented:
I've requested that this question be closed as follows:

Accepted answer: 0 points for PetranAnton's comment #a41164284

for the following reason:

I could implement the code, with minor changes to fit my environment, and it worked the first time.
0
Gustav BrockCIOCommented:
Great. Then mark the solutions as answers.

You can bing/google on the API call URLDownloadToFile.

For the file import, use the help from Access itself.

/gustav
0
Eric ShermanAccountant/DeveloperCommented:
I am confused ... Why no points awarded for the various solutions provided???

ET
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Anton GreffrathAuthor Commented:
Quick Response and to the point. . .
0
Anton GreffrathAuthor Commented:
ET, I am new to this User Group, Am I involved in allocating points for this solution?
0
Gustav BrockCIOCommented:
Thank you for - eh - nothing ...

/gustav
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Access

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.