[thelist] Large Monthly File Imports and Exports

Chris Anderson Chris at activeide.com
Thu Jul 3 16:54:47 CDT 2008

> files are approaching 2G in physical size.  
> The client wants this done in Microsoft Access (2003).  

LOL (Sorry - I was envisaging them wanting to import that into a JET
database rather than using Access as the front-end)

> The Express editions of 2005 and 2008 are free to download and use but
> they wont give them DTS (SSIS).  

They also have size limits (which are around the 2Gb mark IIRC)

> I have a developer copy of SQL Sevrver 2000
> however I am unsure if this can be "distributed" with a setup program.

No it cannot
If you went the SQL Server route, they would be required to use Standard
at least (the "smallest" version that isn't Express which has been ruled

> I am thinking BCP or some bulk
> import and slap a user interface on it with VB 6 and add some
> tables in SQL Server 2000, to allow them to rerun exports and to do

Sounds good.
The only tricky bit may be if the file is corrupt in any way (the
handling of structural file problems will be with the bulk loading tool
you use), but that's the nature of loading data in bulk!

> they
> dont have SQL Server 2000.

Have you considered MySQL?
It has bulk import facilities as well (LOAD DATA INFILE [1]) and can
support the sizes you are looking at - and for free as long as you don't
sell it (and it sounds like an internal tool)

[1] http://dev.mysql.com/doc/refman/5.0/en/load-data.html

More information about the thelist mailing list