VB & Database, help: vb 6.0 / ado code to copy a table from one mdb to another

help: vb 6.0 / ado code to copy a table from one mdb to another

Author	Message
Harinatha Reddy Gorl #1 / 3	help: vb 6.0 / ado code to copy a table from one mdb to another HI No need to open to connections..just try this: you have to use SELECT..INTO.. and One connection SELECT * INTO NewTable FROM SourceTable IN 'C:\yourpath\SourceMDB.mdb' Harinatha Reddy Gorla Software Engineer Smart Software Technologies, Hyderabad, India *** Sent via Developersdex http://www.--.com/ ** Don't just participate in USENET...get rewarded for it!
Sun, 27 Jun 2004 19:03:37 GMT

andy #2 / 3	help: vb 6.0 / ado code to copy a table from one mdb to another Hi, Should I open the connection for the first table and first define a Recordset or use ADOX? Could you please explain in more details? Thanks, andy Quote: >-----Original Message----- >HI >No need to open to connections..just try this: >you have to use SELECT..INTO.. >and One connection >SELECT * INTO NewTable >FROM SourceTable IN 'C:\yourpath\SourceMDB.mdb' >Harinatha Reddy Gorla > Software Engineer >Smart Software Technologies, >Hyderabad, India >* Sent via Developersdex http://www.developersdex.com * >Don't just participate in USENET...get rewarded for it! >.
Sun, 27 Jun 2004 22:58:10 GMT

Justin Rosken #3 / 3	help: vb 6.0 / ado code to copy a table from one mdb to another As far as I know you'll have to use one connection to do this. This should work: Dim cnnTarget As New ADODB.Connection Dim strCommand As String Dim lngRecords as long cnnTarget.ConnectionString = _ "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" _ & "C:\path\TargetDB.mdb" cnnTarget.Open strCommand = "SELECT * INTO [NewTableName] " _ & "FROM [SourceTableName] IN "C:\path\SourceDB.mdb" cnnSource.Execute strCommand, lngRecords * Sent via Developersdex http://www.developersdex.com * Don't just participate in USENET...get rewarded for it!
Mon, 28 Jun 2004 02:03:12 GMT

Page 1 of 1

[ 3 post ]