Boss: So, currently, you have our information stored in Access.
GtDS: Yes.
Boss: And every day, you have a VBA script that refreshes our data.
GtDS: Yes.
Boss: How does it do that?
GtDS: Do we have doughnuts?
Boss: Please stay on topic in this imaginary, but potential, conversation.
GtDS: Sorry.
Boss: So, what does your script do?
GtDS: It removes existing data for the current quarter, and then re-imports updated information from the current quarter's CSV file.
Boss: Is that all?
GtDS: Please don't interrupt me.
Boss: Sorry. Doughnut?
GtDS: Thank you. Anyway, after the current quarter's data is re-imported..
Boss: Does "re-imported" need a hyphen?
GtDS. Dunno. Was wondering that myself. Anyway, after the current quarter's data is re-imported, or reimported, two queries are run. Each looks at the entire data set and does some SQL sorting and grouping, resulting in two smaller tables.
Boss: Which we then turn into PivotTables in Excel?
GtDS: Totally.
Boss: However, you've said that we're now hitting Access' 2GB limit, so you want to put everything into MySQL, instead?
GtDS: Right. Have a doughnut.
Boss: But you need to know what sort of tool can be used to pull off these tricks on a Windows box?
GtDS: Yes. In the past, I've used PHPMyAdmin to upload information and perform some queries. But I need to perform scripted actions, like that current-quarter bit we discussed just a few seconds ago.
Boss: You said that MattKime...
GtDS: How'd you know his name? He's some guy on the internet.
Boss: I'm that good. Anyway, Matt said that you can use the command line for such things.
GtDS: Yeah, but I don't know how that works for scripting. Can a script be saved as a text file? If so, what language is the script it? I need to know this sort of stuff before I can feel confident in recommending MySQL as a solution.
Boss: Have some cash.
GtDS: Thank you.
Boss: Want to knock off early?
GtDS: No, thanks. Strong work ethic and all that.
Boss: Okay. Just let me know about that scripting a MySQL database when you have a chance?
GtDS: You got it.