Working around Access' 2GB limit

[Greg the dogsitter]

mattkime Wrote:
-------------------------------------------------------
> >>Not feasible, in this particular
> situation.
>
> Then they want what they can't have.
>
> $400 for a Mac Mini with MySQL on it.
>
> How much is your time worth?

You don't need to convince me there may be better software for this task.

What's the MySQL equivalent of doing a scripted VBA import in Access? For instance, I have a script that loops through every quarter from 2005_01 to current, and imports one file for each quarter. How would that by done with MySQL?

[mattkime]

>>How would that by done with MySQL?

Command line with the mysql client.

OR

You can use MySQL as a data source in access

[mattkime]

>>You don't need to convince me there may be better software for this task.

ahh....one of those clients

[maurycy]

MS SQL Server 2005 Express edition has database limit of 4GB. This will double your available db space.

Maurycy