Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 *** |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Obtaining a single Access record from Excel input | Links and Linking in Excel | |||
Using Excel spreadsheet as input to Access | Excel Discussion (Misc queries) | |||
How do I access data stored in a SQL server for vlookup function? | Excel Worksheet Functions | |||
Changing data access from MSAccess2000 to SQL Server | Excel Programming | |||
Using OWC10 to access an Excel file with linked SQL Server | Excel Programming |