I have to import large text file(about 10 to 15 mb) into access database. The file is in fixed width format.
Each line contains one record. As it is not a simple "Just dump into" import but requires some intermediate calculations and updation into 4 different tables.
I have wriiten a project for this but it takes lot of time to finish the process and seems that computer is hanged up.
If anybody know any better strategy or a sleek way to do this then please let know.
I have asked this thing before also but didn't get any better suggestions.
Thanx a lot in advance.