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.

yongyih

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 McCracken

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

pfjluik

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

bcp5190

ASKER

converting to xml sounds great but any codding help will be apriciated. Thanks,

ASKER CERTIFIED SOLUTION

miron

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Netminder

Netminder

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

Netminder

Force/accepted by

Netminder
Community Support Moderator
Experts Exchange