I have data lists including email, fname, lname, ip, type fields. Mainly these files are sent .csv between servers.
Some have more than a million records. I use Access 2003 to manage and export in csv files that are less than 2mg in size for upload. the 2mg limit I can not change.
So, I want a script or routine, macro, or module that can call the big file, make smaller files 2gm and kept in the same 'group' for merging later.
For the experienced Database scripter this should be very easy. Please keep it simple.