MS Access - MySQL export

[GrantZ]

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:

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

Is it possible to do? If yes, how?

Thanks

Edit: Using MS Office 2010

 

[The Howling Wolves]

Hi GranZ,
Welcome to Win 7 Forums.
Will send someone your way soon.
You want just to export the code and not the content?

 

[GrantZ]

Thank you, The Howling Wolves.
I need just the code, through knowing how to export the content might be useful as well.

 

[The Howling Wolves]

Export Access reports to Word documents - Access - Microsoft Office

Read the following or while you are in Access hit export and follow directions. IMO

 

[GrantZ]

Sorry for misunderstanding, i meant export content to MySQL. Example:

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');

Anyway, the thing i need is export of the database structure to MySQL.

 

[The Howling Wolves]

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.

 

[GrantZ]

That really is not what i need.
It's 5:10 A.M. here, got to go for a while.

 

[TimStitt]

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 )

 

[GrantZ]

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.

 

[The Howling Wolves]

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.

 

[TimStitt]

Interesting, I'm pretty familiar with Access 2007, but I'm yet to install Access 2010 and compare them. I might take a look later and for the sake of updating info come back here if I learn anything about exporting Schema's, I'm sure you can export it to xml or at least to an SQL script.

Anyways, that doesn't help you Thanks for getting back to us and good luck with your project.

-Timo