bcp5190
asked on
Upload and convert mdb file from vb application to web server sql server 2000?
How can i upload mydb.mdb file to sql server 2000 on web server from clients vb application through internet ftp or http. (I'm assuming if clients have internet connection)
How can i do this so the upload time will be minimum.
Hint: how about if i convert all of the table into text file and upload the text file to web server then i can transfer to sql server. Is it possible? Or is there
any better solution?
I just want to minimize the upload time.
I want to store all data from access2000 from client vb application to sql server on web server.
Is access2002 will be helpful in this kind of upload transaction?
Any help or hint will be apriciated.
How can i do this so the upload time will be minimum.
Hint: how about if i convert all of the table into text file and upload the text file to web server then i can transfer to sql server. Is it possible? Or is there
any better solution?
I just want to minimize the upload time.
I want to store all data from access2000 from client vb application to sql server on web server.
Is access2002 will be helpful in this kind of upload transaction?
Any help or hint will be apriciated.
We were able to convert our Access database to MS SQL using SQL Server DTS. I don't have the details (I'm at home) but this might work.
If you still need an answer next week I'll see if I can send the instructions on how to set it up.
good luck
mlmcc
If you still need an answer next week I'll see if I can send the instructions on how to set it up.
good luck
mlmcc
Why not converting your Access data to a XML document, which can be imported into your SQL server.
For more info read the VB & SQL Server help. (search for XML)
grtz.
Peter
For more info read the VB & SQL Server help. (search for XML)
grtz.
Peter
ASKER
converting to xml sounds great but any codding help will be apriciated. Thanks,
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
bcp5190,
Some of these questions have been open for some time, and our records show you logged in as recently as Jan 23, 2002. Please resolve them appropriately as soon as possible.
https://www.experts-exchange.com/jsp/qShow.jsp?ta=osgen&qid=20250789
https://www.experts-exchange.com/jsp/qShow.jsp?ta=win2k&qid=20224108
https://www.experts-exchange.com/jsp/qShow.jsp?ta=win2k&qid=20224027
https://www.experts-exchange.com/jsp/qShow.jsp?ta=win2k&qid=20218730
https://www.experts-exchange.com/jsp/qShow.jsp?ta=msoffice&qid=20249772
https://www.experts-exchange.com/jsp/qShow.jsp?ta=mssql&qid=20255121
https://www.experts-exchange.com/jsp/qShow.jsp?ta=mssql&qid=20250781
https://www.experts-exchange.com/jsp/qShow.jsp?ta=mssql&qid=20248828
https://www.experts-exchange.com/jsp/qShow.jsp?ta=mssql&qid=20247239
https://www.experts-exchange.com/jsp/qShow.jsp?ta=mssql&qid=20244374
https://www.experts-exchange.com/jsp/qShow.jsp?ta=java&qid=20189160
https://www.experts-exchange.com/jsp/qShow.jsp?ta=javascript&qid=20241876
https://www.experts-exchange.com/jsp/qShow.jsp?ta=javascript&qid=20187022
https://www.experts-exchange.com/jsp/qShow.jsp?ta=visualbasic&qid=20249686
https://www.experts-exchange.com/jsp/qShow.jsp?ta=visualbasic&qid=20248047
https://www.experts-exchange.com/jsp/qShow.jsp?ta=visualbasic&qid=20246855
https://www.experts-exchange.com/jsp/qShow.jsp?ta=visualbasic&qid=20246318
https://www.experts-exchange.com/jsp/qShow.jsp?ta=visualbasic&qid=20244409
https://www.experts-exchange.com/jsp/qShow.jsp?ta=visualbasic&qid=20242375
https://www.experts-exchange.com/jsp/qShow.jsp?ta=visualbasic&qid=20093765
https://www.experts-exchange.com/jsp/qShow.jsp?ta=asp&qid=20249476
https://www.experts-exchange.com/jsp/qShow.jsp?ta=asp&qid=20158800
https://www.experts-exchange.com/jsp/qShow.jsp?ta=html&qid=20235587
https://www.experts-exchange.com/jsp/qShow.jsp?ta=iis&qid=20186130
Thanks,
Netminder
Community Support Moderator
Experts Exchange
Some of these questions have been open for some time, and our records show you logged in as recently as Jan 23, 2002. Please resolve them appropriately as soon as possible.
https://www.experts-exchange.com/jsp/qShow.jsp?ta=osgen&qid=20250789
https://www.experts-exchange.com/jsp/qShow.jsp?ta=win2k&qid=20224108
https://www.experts-exchange.com/jsp/qShow.jsp?ta=win2k&qid=20224027
https://www.experts-exchange.com/jsp/qShow.jsp?ta=win2k&qid=20218730
https://www.experts-exchange.com/jsp/qShow.jsp?ta=msoffice&qid=20249772
https://www.experts-exchange.com/jsp/qShow.jsp?ta=mssql&qid=20255121
https://www.experts-exchange.com/jsp/qShow.jsp?ta=mssql&qid=20250781
https://www.experts-exchange.com/jsp/qShow.jsp?ta=mssql&qid=20248828
https://www.experts-exchange.com/jsp/qShow.jsp?ta=mssql&qid=20247239
https://www.experts-exchange.com/jsp/qShow.jsp?ta=mssql&qid=20244374
https://www.experts-exchange.com/jsp/qShow.jsp?ta=java&qid=20189160
https://www.experts-exchange.com/jsp/qShow.jsp?ta=javascript&qid=20241876
https://www.experts-exchange.com/jsp/qShow.jsp?ta=javascript&qid=20187022
https://www.experts-exchange.com/jsp/qShow.jsp?ta=visualbasic&qid=20249686
https://www.experts-exchange.com/jsp/qShow.jsp?ta=visualbasic&qid=20248047
https://www.experts-exchange.com/jsp/qShow.jsp?ta=visualbasic&qid=20246855
https://www.experts-exchange.com/jsp/qShow.jsp?ta=visualbasic&qid=20246318
https://www.experts-exchange.com/jsp/qShow.jsp?ta=visualbasic&qid=20244409
https://www.experts-exchange.com/jsp/qShow.jsp?ta=visualbasic&qid=20242375
https://www.experts-exchange.com/jsp/qShow.jsp?ta=visualbasic&qid=20093765
https://www.experts-exchange.com/jsp/qShow.jsp?ta=asp&qid=20249476
https://www.experts-exchange.com/jsp/qShow.jsp?ta=asp&qid=20158800
https://www.experts-exchange.com/jsp/qShow.jsp?ta=html&qid=20235587
https://www.experts-exchange.com/jsp/qShow.jsp?ta=iis&qid=20186130
Thanks,
Netminder
Community Support Moderator
Experts Exchange
There has been no activity in this question in quite some time, and it looks like it has been abandoned. As part of our ongoing mission to clean up the topic areas, a Moderator will finalize this question within the next seven (7) days. At that time, either I or one of the other Moderators will force/accept the comment of miron.
DO NOT ACCEPT THIS COMMENT AS AN ANSWER. If you have further comments on this question or the recommendation, please leave them here.
Netminder
Community Support Moderator
Experts Exchange
DO NOT ACCEPT THIS COMMENT AS AN ANSWER. If you have further comments on this question or the recommendation, please leave them here.
Netminder
Community Support Moderator
Experts Exchange
Force/accepted by
Netminder
Community Support Moderator
Experts Exchange
Netminder
Community Support Moderator
Experts Exchange
<First table name>
data
data
.
.
<Second table name>
data
data
.
.
then upload it.
if do like this, you can know where the records come from.
Another way to minimize upload time is zip your Access 2000 database.
Hope this can help you.
Good Luck ^_^