mysql to access or access syntax

I'm doing a small favor for a friend, he wants an Access database. I only know MySQL. I tried to use phpmyadmin to generate a CVS file and couldn't get it. Does someone know where I can find Access syntax for creating tables? (I've looked everywhere on M$ website & other sites).

I just want to create a .sql like file with all the tables and their structures to run in Access.
(NOTE: I don't use windows so I don't have it installed on my PC or I would do it the long way in Access).

Export it as standard SQL from phpMyAdmin

Import is as a standard SQL into MSAccess.

Think outside the box!


Both of them speak SQL, just use the comman language

LOL

So your saying if I type:

CREATE TABLE current_orders (
invoice_number int(11) unsigned NOT NULL auto_increment,
customer_id int(11) unsigned NOT NULL default '0',
date int(11) NOT NULL default '0',
.......

That Access is going to understand that?

No, access will not understand that.

It has it own set of non-standard DDL statements

http://msdn.microsoft.com/library/d...ue&hidetoc=true

It has a section on create table and there are some related links at the bottom.