Hi, I'm making a little database for web, but i can't find how to export it (the code, not the content). If possible, the result should look like this example:
Is it possible to do? If yes, how?Code:CREATE TABLE `tasks` ( `id` int(11) NOT NULL auto_increment, `text` varchar(100) NOT NULL, `added` datetime NOT NULL, `done` enum('yes','no') NOT NULL default 'no', PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8
Thanks
Edit: Using MS Office 2010
Hi GranZ,
Welcome to Win 7 Forums.
Will send someone your way soon.
You want just to export the code and not the content?
Thank you, The Howling Wolves.
I need just the code, through knowing how to export the content might be useful as well.
Export Access reports to Word documents - Access - Microsoft Office
Read the following or while you are in Access hit export and follow directions. IMO
Sorry for misunderstanding, i meant export content to MySQL. Example:
Anyway, the thing i need is export of the database structure to MySQL.Code:INSERT INTO `tasks` VALUES('1','task 1','2010-01-24 18:16:05','no'), ('2','task 2','2010-01-24 18:17:45','no'), ('3','task 3','2010-01-24 18:18:12','yes');
Here a trial offer you may or may not be interested in.
MySQL :: MySQL Enterprise Trial Subscription Order Form
Check back if this is what you wanted.
That really is not what i need.
It's 5:10 A.M. here, got to go for a while.
Hi Grantz,
I'm also a little unclear what you are trying to achieve here. Looking at yoru two queries you are creating a DB schema and inserting data.
Are you trying to export the an Access database schema and import that into MySQL? If so take a look at MDB tools. When doing this, double check all of your column names to ensure that they are not reserved names in MySQL (there's a few we can't use).
-Timo
EDIT: This gives more information. If we are miss-understanding you and it's not the schema, please take us through in baby steps and give an example (we won't take offense :P )
After few hours of playing with trial version of MS Access 2010, i found out that is lacks (at first i thought it's just moved somewhere) the very basic functions i use in school in Access 2007.
I have MS Office 2007 Home & Student edition, which doesn't include the MS Access.
I'm going to write the code manually, because the deadline is 29.7. and it seems to be faster than learning how to use some database designer that I have never used before.
Anyway, thanks for your help. MDB Tools is what I was looking for. Through, i thought it's included in the Access 2010.
After searching for a free(trial) version of MS Access and the MDB tool I found that you have to pay for it.
Sorry we couldn't help more and hope you get your project done in time.
Quote