|
-
Jan 5th, 2004, 09:07 PM
#1
Thread Starter
Frenzied Member
export hard drive RS to website for online DB import
Hi all.
I have an app that runs on my computer, not on a network. The database is Access, app is VB
I want to make online "junior versions" that can import some of the tables from my pc's db. It won't be that complicated though. I want to export the tables from my hard drive db (I guess using the RS.Save method) and then FTP or INET the tables of data to my website and
Then...
go to a page on my website and import the data into the online database, so that the data can be used by the junior applications online.
Likewise, those apps will enter records in one of the tables of the web DB and I will have another webpage that can extract all that data to one file on my server, and go BACK into VB and import those records into the same table in my PCs DB.
Is there an easier way? This app has to stay on the hard drive, so does the db, and I cannot grant access to it via internet.
What would be the way to export an entire table/RS from my DB to a file on my server that could be imported by the web DB?
And vice versa?
Thanks all.
Wengang
Wen Gang, Programmer
VB6, QB, HTML, ASP, VBScript, Visual C++, Java
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|