[Typo3] access -> mysql

[Ries van Twisk]

I don't think that my version of access supports export to ODBC (Access 
2000)..

I have been using this VB script to export all tables to CVS.
I have been trying numerous programs to do a export to mysql but all 
failed one way or the other, or where simply not free (it was a one time 
export).

Ries

Private Sub Knop0_Click()
On Error GoTo Err_ExportDatabaseObjects

'Dim db As Database
'Dim db As DAO.Database

Dim i As Integer
Dim sExportLocation As String

Set db = CurrentDb()

sExportLocation = "C:\Temp\pg\" 'Do not forget the closing back slash! 
ie: C:\Temp\

For Each td In db.TableDefs 'Tables
If Left(td.Name, 4) <> "MSys" Then
    DoCmd.TransferText acExportDelim, , td.Name, sExportLocation & 
td.Name & ".txt", True
End If
Next td

Set db = Nothing
Set c = Nothing

MsgBox "All database objects have been exported as a text file to " & 
sExportLocation, vbInformation

Exit_ExportDatabaseObjects:
Exit Sub

Err_ExportDatabaseObjects:
MsgBox Err.Number & " - " & Err.Description
Resume Exit_ExportDatabaseObjects
End Sub



>>I need to convert a Access DB to mysql so I can import some 
>>data into Typo3's db.
>>I found some 'shareware' programs who do this task for me (all demo
>>versions)
>>Does anyone know a free program that will convert Access to mysql?
>>    
>>
>
>If you need only the Access data, you can (on Win platform) :
>1. Install the MyODBC driver (available on mysql.com).
>2. Add an ODBC DSN pointing to your MySQL server.
>3. Just do File/Export/ODBC in Access and select your ODBC DSN.
>(table structures and data will be send to MySQL)
>4. Point the MySQL structures (add any primary key if necessary).
>
>Voilà!
>-- Hervé Inisan.
>
>
>_______________________________________________
>Typo3-english mailing list
>Typo3-english at lists.netfielders.de
>http://lists.netfielders.de/cgi-bin/mailman/listinfo/typo3-english
>  
>


-- 
R. van Twisk
http://www.metamorf.net

Our Typo3 enabled website: http://www.livetravelguides.com
Instand help for Typo3?    irc:/irc.freenode.net/typo3
Looking for documentation? http://typo3.org/documentation/