Hello Everyone, I am new to the forum and new to access. I have general knowledge in access, but recently started using it seriously. I do not have a problem researching and learning new things, i just need to know what i am looking for!
I am looking for some techniques to perform the steps i will be doing on a daily basis.
1)Import multiple files containing 500k+ lines items into a database(Text Files, Tab Deliminated) (retain original file name the line item came from)
2)Organize base on category(a column on import)
3) Export in manageable chunks (5k a piece) And assign a file number. The file number must be logged. (Each line item should have an original file number, and a internal file number)
4)After file is completed(a different process) Re-Import with additional fields added to each item.
5)Export new items that have not been exported previously.
As of right now i am doing the combing/splitting of the files inside of excel. Then importing the completed data into access and running a query to export into the needed format.
I recently just reached the 2gb cap on access as well!
Any help would be greatly appreciated!!