Windows 7 Forums

Welcome to Windows 7 Forums. Our forum is dedicated to helping you find support and solutions for any problems regarding your Windows 7 PC be it Dell, HP, Acer, Asus or a custom build. We also provide an extensive Windows 7 tutorial section that covers a wide range of tips and tricks.


Windows 7: MS Access - MySQL export

22 Jul 2010   #1
GrantZ

Win XP, 7, Ubuntu, FreeBSD
 
 
MS Access - MySQL export

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


My System SpecsSystem Spec
.
22 Jul 2010   #2
The Howling Wolves

Windows 7 Home Premium 64bit
 
 

Hi GranZ,
Welcome to Win 7 Forums.
Will send someone your way soon.
You want just to export the code and not the content?
My System SpecsSystem Spec
22 Jul 2010   #3
GrantZ

Win XP, 7, Ubuntu, FreeBSD
 
 

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

22 Jul 2010   #4
The Howling Wolves

Windows 7 Home Premium 64bit
 
 

Export Access reports to Word documents - Access - Microsoft Office

Read the following or while you are in Access hit export and follow directions. IMO
My System SpecsSystem Spec
22 Jul 2010   #5
GrantZ

Win XP, 7, Ubuntu, FreeBSD
 
 

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.
My System SpecsSystem Spec
22 Jul 2010   #6
The Howling Wolves

Windows 7 Home Premium 64bit
 
 

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.
My System SpecsSystem Spec
22 Jul 2010   #7
GrantZ

Win XP, 7, Ubuntu, FreeBSD
 
 

That really is not what i need.
It's 5:10 A.M. here, got to go for a while.
My System SpecsSystem Spec
22 Jul 2010   #8
TimStitt

Windows 7 Ultimate 64 bit
 
 

Quote   Quote: Originally Posted by GrantZ View Post
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 )
My System SpecsSystem Spec
23 Jul 2010   #9
GrantZ

Win XP, 7, Ubuntu, FreeBSD
 
 

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.
My System SpecsSystem Spec
23 Jul 2010   #10
The Howling Wolves

Windows 7 Home Premium 64bit
 
 

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.
My System SpecsSystem Spec
Reply

 MS Access - MySQL export




Thread Tools





Similar help and support threads
Thread Forum
Question about installing Mysql server 2008 R2
I have a question about Mysql server 2008 R2 What is my server name if I select to install with "Named Instance" not "Default Instance" with Mixed mode password http://i.imgur.com/P8FoTVT.png I don't know this because I used to install with Named Instance : neneka and mixed mode...
General Discussion
Windows 7 - MySQL ODBC System DSN creation
Hello and thank you for reading my post. My software creates MySQL ODBC System DSNs... ... except it doesn't work with Windows 7. It used to work with the previous Windows OSes including XP, Vista. I've been struggling the whole day trying to find a solution. *** I believe UAC (User...
General Discussion
Mysql install error
Guys When Im Trying To Install The Mysql It Stops And Then Im Getting An Error That Says "The system administrator has set policies to prevent this installation" What I Must To Do??
Software
How to find the cause of mysql's not responding
I've installed xampp for windows 1.7.7. on windows 7 x64. Everythings are fine but mysql does not repond. The port 3306 is opened, but mysql does not answer. For checking this, I installed xampp for windows 1.7.7. on windows 7 x64 as guest on virtualbox, and this opens phpmyadmin without...
BSOD Help and Support
mySQL server... wont start
well i had it installed. everything was perfect. but recently i had to jump to a new administrator user. and my mysql service wont start. i stopped all XAMPP service. i unistalled all XAMPP service.
BSOD Help and Support
phpBB + MySQL + IIS7??
I am trying to install phpBB for testing purposes on my IIS "server". I have MySQL installed, and have created a db with the following info: name: wiki (don't ask me why) user: root password: ****** At the db config, I enter: Type: MySQL with MySQLi Extension DSN: 10.0.0.227 or localhost...
Network & Sharing

Our Sites

Site Links

About Us

Find Us

Windows 7 Forums is an independent web site and has not been authorized, sponsored, or otherwise approved by Microsoft Corporation. "Windows 7" and related materials are trademarks of Microsoft Corp.

Designer Media Ltd

All times are GMT -5. The time now is 14:00.

Twitter Facebook Google+



Windows 7 Forums

Seven Forums Android App Seven Forums IOS App