Access
that's easy.
1) Download and install MySQL
2) Download Andargor's database
3) In MySQL's command line client, tell it to Create Database DnD35;
4) In MySQL's command line client, tell it to \. <path to Andargor's huge SQL textfile here>;
5) Download and install MySQL Connector/ODBC
6) Configure the ODBC connector to point to MySQL's DnD35 database
7) In Access, create your 3.5 database
8) In Access, Get External Data - > Link Tables
9) In the dialog box, choose the drop-down menu of file type: ODBC Databases ()
from there, you can figure it out. You can instead choose to Import Tables in step 8, but then you wind up with duplicate data occupying like 60MB on your drive.
Also note the semicolon in steps 3 and 4. If you press enter before the semicolon, the client keeps prompting you until you give it that ;
I'm still a little fresh to the world of SQL, and I just wrote those steps from memory, so I may only be about 95% right, but it's close enough for jazz.
Oh! I almost forgot. When configuring the ODBC connector, note the defaults. They are not the same defaults that MySQL uses. When you install MySQL it assumes your account is root@localhost and you give it a password. The ODBC connector will call you ODBC@localhost and default to no password. Make sure that the ODBC agrees with the MySQL.
Also, for you Access users, did you know that when you switch back-and-forth between query design view and data view, that that button is actually a drop-down box that can also give you SQL view? This is how I started teaching myself SQL.
