[TYPO3] Import an Access Database

[Eckbert Peter Dollhofer]

Hi,
you could just export the users table from typo3 to .csv or excel and  
with phpMyAdmin or another tool add your e-mail addresses from Access  
and re-import the data. May be just update the tables. Just make sure  
nobody is altering his user information in between + of course backup  
your DB before you start.
Ciao
Eckbert
Am 07.03.2007 um 17:17 schrieb Bing Du:

>> Hi! I have a buch of data in Access database, and containing an  
>> email of
>> 500
>> users. I would like to add this data into my typo3 user's e-mail.  
>> is there
>> any method how to do it or do I really have to do it manually? 
>> (this one i
>> would not prefer unless no other way)
>>
>> I'm using Microsoft Access 2003, and Typo 4.0.2 with mysql 4.1.11, I
>> already
>> have 500 users in my typo3 system with no e-mail, this is because   
>> in the
>> early of user input we have nothing to do with the e-mail address,  
>> but now
>> we need them.
>
> Based on my limited knowledge of Typo3, I'm not aware of it has any
> function that can pull data out of Access and insert into MySQL  
> directly.
> On Internet, there are quite a few conversion tools, like  
> access2mysql,
> that you can use to extract what you want from Access and transfer to
> MySQL.
>
> Bing
> _______________________________________________
> TYPO3-english mailing list
> TYPO3-english at lists.netfielders.de
> http://lists.netfielders.de/cgi-bin/mailman/listinfo/typo3-english