Actually, there is a way to convert this data without having to buy any
new software. The catch is that you have to write a little bit of code
to do it.
GoTo MSDN and download Mdac2.5 and Mdac2.6. This is so you can use COM
based ADO (as opposed to ADO.Net) to access your Acc2002 table. Mdac2.5
contains Jet4.0, Mdac2.6 is an update for COM ADO. I do this all the
time because at my workplace we also use Office97 (and I'm using .Net to
interface with Sql Server - what a mix!). Here is a provider string for
Acc2002 table.
--------------------------------------------------
Sub Get2002Data()
Dim cmd As ADODB.Command, RS1 As ADODB.Recordset
Dim RS2 As DAO.Recordset, i As Integer
Set RS2 = CurrentDB.OpenRecordset("tbl97")
Set cmd = CreateObject("ADODB.Command")
cmd.ActiveConnection = "Provider = Microsoft.Jet.OLEDB.4.0; Persist
Security Info=false;" _
& "Data Source=C:\Dir1\acc2002.mdb"
cmd.CommandType = adCmdText
cmd.CommandText = "Select * From tbl2002"
Set RS1 = cmd.Execute
Do While Not RS1.EOF
For i = 0 to RS1.Fields.Count - 1
RS2(i) = RS1(i)
Next
RS2.Update
RS1.MoveNext
Loop
RS2.Close
RS1.Close
cmd.ActiveConnection.Close
End Sub
----------------------------------------------
When you load Mdac you have to make a reference to Microsoft ActiveX
Data Object 2.6 Library in Tools/References of your code module.
Rich
*** Sent via Developersdex
http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!