We help IT Professionals succeed at work.

Upload and convert mdb file from vb application to web server sql server 2000?

bcp5190
bcp5190 asked
on
Medium Priority
285 Views
Last Modified: 2010-05-02
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.
Comment
Watch Question

Commented:
If you want to convert it to text file and upload, may be you can set the text file format like this.

<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 ^_^
Mike McCrackenSenior Consultant
CERTIFIED EXPERT
Most Valuable Expert 2011
Top Expert 2013

Commented:
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

Commented:
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

Author

Commented:
converting to xml sounds great but any codding help will be apriciated. Thanks,
CERTIFIED EXPERT
Commented:
if you import Access tables into comma delimited format flat files it will import into SQL Server like a super-sonic jet using BULK INSERT <table_name> from '<file_name>'

or uploaded mdb files with well known name can be used to create a linked server on sql server and as such can be queried directly from sql server, as if they were native tables. Both 'bulk insert' and 'sp_addlinkedserver' described with examples in the on-line documentation for sql server.

Cheers
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.

http://www.experts-exchange.com/jsp/qShow.jsp?ta=osgen&qid=20250789
http://www.experts-exchange.com/jsp/qShow.jsp?ta=win2k&qid=20224108
http://www.experts-exchange.com/jsp/qShow.jsp?ta=win2k&qid=20224027
http://www.experts-exchange.com/jsp/qShow.jsp?ta=win2k&qid=20218730
http://www.experts-exchange.com/jsp/qShow.jsp?ta=msoffice&qid=20249772
http://www.experts-exchange.com/jsp/qShow.jsp?ta=mssql&qid=20255121
http://www.experts-exchange.com/jsp/qShow.jsp?ta=mssql&qid=20250781
http://www.experts-exchange.com/jsp/qShow.jsp?ta=mssql&qid=20248828
http://www.experts-exchange.com/jsp/qShow.jsp?ta=mssql&qid=20247239
http://www.experts-exchange.com/jsp/qShow.jsp?ta=mssql&qid=20244374
http://www.experts-exchange.com/jsp/qShow.jsp?ta=java&qid=20189160
http://www.experts-exchange.com/jsp/qShow.jsp?ta=javascript&qid=20241876
http://www.experts-exchange.com/jsp/qShow.jsp?ta=javascript&qid=20187022
http://www.experts-exchange.com/jsp/qShow.jsp?ta=visualbasic&qid=20249686
http://www.experts-exchange.com/jsp/qShow.jsp?ta=visualbasic&qid=20248047
http://www.experts-exchange.com/jsp/qShow.jsp?ta=visualbasic&qid=20246855
http://www.experts-exchange.com/jsp/qShow.jsp?ta=visualbasic&qid=20246318
http://www.experts-exchange.com/jsp/qShow.jsp?ta=visualbasic&qid=20244409
http://www.experts-exchange.com/jsp/qShow.jsp?ta=visualbasic&qid=20242375
http://www.experts-exchange.com/jsp/qShow.jsp?ta=visualbasic&qid=20093765
http://www.experts-exchange.com/jsp/qShow.jsp?ta=asp&qid=20249476
http://www.experts-exchange.com/jsp/qShow.jsp?ta=asp&qid=20158800
http://www.experts-exchange.com/jsp/qShow.jsp?ta=html&qid=20235587
http://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
Force/accepted by

Netminder
Community Support Moderator
Experts Exchange

Explore More ContentExplore courses, solutions, and other research materials related to this topic.