ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   input excel data to access db in web server (https://www.excelbanter.com/excel-programming/349187-input-excel-data-access-db-web-server.html)

x taol

input excel data to access db in web server
 


there are 2 files
one is excel file in my computer, the other is access file in the web
server.
just , in local , i already know how to input data method .
but i don't know method data input in computer in the distance.
for example, in local.....
set db = opendatabase(thisworkbook.path & "\" & db_name)
srQry="select * from tblTest"
set rs = db.openrecordset(srQry)
..........

by the way , for example
www.xxxdomain.com/testFolder/db_name.mdb
id : testID
pw : 3333

In short, i want to input data any excel data in computer in new york to
access db in computer in sanfrancisco.


*** Sent via Developersdex http://www.developersdex.com ***


All times are GMT +1. The time now is 06:35 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com