Is it possible to use Microsoft Access as a way to input data into a MySQL database?

How would this be accomplished? Do I design the tables in Access first, and if so, how is it exported to MySQL.

I have a limited budget/toolset, but I do have MS Access (03), WAMP server with PHPMyAdmin. Or would it be better to create the table in Excel?

Also, how do I "export" from an .xls or access file into PHPMyAdmin? I noticed there is a .csv export, but I guess my question is "how" is it laid out in an xls spreadsheet?

Just put the fields horizontally, or vertically: for example: First Name, Last Name, Address, City, etc. Does that go across the top or does it go top to bottom or does it matter?

Any links or resources (books) you recommend would be much appreciated?

Thanks!

Access probably isnt the best tool for creating a MySQL DB. MySQL itself does however offer plenty of free tools for creating and managing MySQL DB's.

http://www.mysql.com/products/tools/

I would personally design my DB in something more MySQL centric. You can export in excel to CSV and PhpMyAdmin will allow you to import that data via CSV. Here is an example CSV file:

http://www.allnetic.com/working-time-tracker/manual/index.html?reportcsvexample.html

we use a tool call myaccess, It is an AddIn for MS Access that allows the administration of MySQL databases from within Access. it work under access 97, access 2000, for more information you can go to hiden.org - software - myaccess

we use a tool call myaccess, It is an AddIn for MS Access that allows the administration of MySQL databases from within Access. it work under access 97, access 2000, for more information you can go to hiden.org - software - myaccess

Wow, that looks like a really useful tool. Have you used it and how were the results?

I will give this one a try, but in case I end up just doing it the other way, this may be a useful tool for the people to use, once I built the site and they can use Access to maintain the product database.

Thanks for this link! I really appreciate it! :agree:

HI

We have use MYAccess add in for 3 years, It is a greate administration tool to MySQL databases from within Access. The end user dont need to know SQL statement to maintain table structure.