Windows 7: MS Access - MySQL export

GrantZ · 22 Jul 2010

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:

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

Is it possible to do? If yes, how?

Thanks

Edit: Using MS Office 2010

The Howling Wolves · 22 Jul 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?

GrantZ · 22 Jul 2010

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 · 22 Jul 2010

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 · 22 Jul 2010

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

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

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

The Howling Wolves · 22 Jul 2010

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 · 22 Jul 2010

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

TimStitt · 22 Jul 2010

Quote: Originally Posted by GrantZ

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 )

GrantZ · 23 Jul 2010

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 · 23 Jul 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.

Windows 7: MS Access - MySQL export

MS Access - MySQL export problems?