Link to home
Start Free TrialLog in
Avatar of Murray Brown
Murray BrownFlag for United Kingdom of Great Britain and Northern Ireland

asked on

Access - import data from an ASP.net SQL data

Hi

Is it possible to import data into my Access database directly from a SQL database that I have hosted on an ASP.net 4 site of mine?
Avatar of Boyd (HiTechCoach) Trimmell, Microsoft Access MVP 2010-2015
Boyd (HiTechCoach) Trimmell, Microsoft Access MVP 2010-2015
Flag of United States of America image

If the hosting company provides remote access to the SQL server then you can link to the tables from Access via ODBC.

I would recommend contacting the hosting provider for instructions for the servers.. Severy prodiver can have it set up different.
Avatar of Murray Brown

ASKER

Hi. My hosting company say that it is possible gain access to my hosted SQL database. How do you actually set this up?
Would you mind sharing a link to the hosting provider you are using?

I normally go to the control panel and create an ODBC connection for an SQL server using the information for the hosting provider's server.

I use www.webafrica.co.za
Would you be able to give me an example of the code you would use
Thanks
ASKER CERTIFIED SOLUTION
Avatar of Boyd (HiTechCoach) Trimmell, Microsoft Access MVP 2010-2015
Boyd (HiTechCoach) Trimmell, Microsoft Access MVP 2010-2015
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
thanks for all the help