Re: dumping table structure of Access database to a text file

Hi I haven't done this for a while, but here goes .... - Use Tools/Analyse/Documenter - Select Tables Tab - Check the tables to document (maybe one at a time?) - There is a place to set the attributes you want (name,type,field length, decimals,etc) - Run the documenter - Save the output as a table (Access assigns a table name like object_definition) - Export the objects table to text ..... phew, hope it works for you Dell Coleman PICO Technology Corp. Kevin Beckford wrote: > > I've got to convert an Access database to mysql. I am looking for the > equivalent of 'mysqldump' in Access. I can export the data, but not the sql > table structure. Is there an easy way to do this? > I apologize for the off topic post, but this is urgent... > ______________________________________ > Kevin Beckford > Programmer > Big Orbit - Specializing in new media for youth > www: http://www.bigorbit.com > email: kbeckford@bigorbit.com > [t] 416.516.0705 > [f] 416.516.9256 > > "Intelligence is a tool used achieve goals, however goals are not always chosen > wisely..." > > -- > PHP General Mailing List (http://www.php.net/) > To unsubscribe, e-mail: php-general-unsubscribe@lists.php.net > For additional commands, e-mail: php-general-help@lists.php.net > To contact the list administrators, e-mail: php-list-admin@lists.php.net