How to write from Access MDB to another Access MDb ?

[itayzoro]

How to write from Access MDB to another Access MDb ?

i try this but its wrong 

[code]
Dim sw As New StreamWriter("C:\howto.mdb")

Dim MyString As String 
       
MyString = "10,20,35"  
        
sw.Write(MyString)
       
 sw.Close()

[/CODE]

BTW Visual basic 2003 only

 

[JuggaloBrotha]

What you need to do is create a connection (it's in the oledb namespace) to both databases, and a DataAdapter to get at the data that you need to read from then using another DataAdapter you'll write the data to the other database.

You'll also be using DataSet's, so you should familiarize yourself with those too.

 

[itayzoro]

1 i need to Create MS db
2 copy table from ANOTHER MS db to the one i create

so far i can just Creat db :

Imports ADOX

 Dim cat As New Catalog

cat.Create("Provider=Microsoft.Jet.OLEDB.4.0;" & _
"Data Source=C:\BlankDb.mdb")

 cat = Nothing