NEED HELP~!
Does anyone know how to import access data into sql server using vb.net? I want to create a openfiledialog and allow user to choose which access file to be imported into the server.
Thank you so much~~ >.<
PS. I am just a beginner of vb.net. So would u pls tell me the solution in detail?
THANKS~~~!!
sophie_kiu
0
Light Poster
Recommended Answers
Jump to PostYou can try this.
Put a button of your form and call it btnImport.
Then add this code.Private Sub btnImport_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnImport.Click Dim fileName As String = "" Dim ofd As New OpenFileDialog If ofd.ShowDialog = Windows.Forms.DialogResult.OK Then fileName …
Jump to PostGood luck! :)
Jump to PostOne of the most likely causes for that ISAM error is that you may be missing the JET 4.0 data access component.
It's available for download from this link.And as for your other question.
And yes, you need to change <tablename> into the name of …
Jump to PostOk.
On what line in the method PerformImportToSql does this error occur?
And what version of Access database are you trying to read? x<=2003 or 2007?
Jump to PostNo. It has nothing to do with the server version.
And I was just making sure of the Access version.There's obviously something hinky with the connection string.
If everything is as it should be, your connection string should look something like this, (where C:\mydatabase.mdb is YOUR path and …
All 24 Replies
Oxiegen
88
Basically an Occasional Poster
Featured Poster
sophie_kiu
0
Light Poster
Oxiegen
88
Basically an Occasional Poster
Featured Poster
sophie_kiu
0
Light Poster
sophie_kiu
0
Light Poster
Oxiegen
88
Basically an Occasional Poster
Featured Poster
sophie_kiu
0
Light Poster
Oxiegen
88
Basically an Occasional Poster
Featured Poster
sophie_kiu
0
Light Poster
sophie_kiu
0
Light Poster
sophie_kiu
0
Light Poster
Oxiegen
88
Basically an Occasional Poster
Featured Poster
sophie_kiu
0
Light Poster
sophie_kiu
0
Light Poster
Oxiegen
88
Basically an Occasional Poster
Featured Poster
sophie_kiu
0
Light Poster
Oxiegen
88
Basically an Occasional Poster
Featured Poster
sophie_kiu
0
Light Poster
sophie_kiu
0
Light Poster
Oxiegen
88
Basically an Occasional Poster
Featured Poster
sophie_kiu
0
Light Poster
Oxiegen
88
Basically an Occasional Poster
Featured Poster
sophie_kiu
0
Light Poster
Oxiegen
88
Basically an Occasional Poster
Featured Poster
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.