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

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

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

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

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

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

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

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

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

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

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 for2: MS Access - MySQL export
Thread Forum
Solved Mysql install error Software
Win 7 , WAMP MySQL workbench - cannot access project on other computer Network & Sharing
How to find the cause of mysql's not responding BSOD Help and Support
Microsoft Virtual PC (mysql help) Virtualization
Ms Access 2010 or MySQL Microsoft Office
phpBB + MySQL + IIS7?? Network & Sharing
MYSQL Error after IE patch 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 10:02 PM.
Twitter Facebook Google+



Windows 7 Forums

Seven Forums Android App Seven Forums IOS App
  

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33