Importing files to Access 2003

One of my friend was trying to import a text file into Access 2003. He had actually two 500MB csv files. When he tried the first file, it imported all right and the database table was created. But when he tried importing the other file, the import wizard would complete but he wouldn’t find the data imported.

Reason: MS Access 2003 only supports a maximum of 2GB per database with 2GB Max size for table.

His first file became a 1.2GB of data when imported to access and therefore for the next import, Access would quitely decline it without even prompting the reason. After about 30 mins of hair raising and pulling, we found out the actual reason.

More details can be found here :