text file
I was able to convert a text file into Access but first I converted it into an excel spreadsheet. This worked well when I imported the file as a link. However, how do I import this file into access automatically plus give the users the option to add fields when needed? I think I may need some kind of code to do this but I am not sure how to write it.
On another note I am very new in writing VBA code. What books do you recommend for beginners. Like what is Dim, Variables, Do Loop, Do While, Constant, etc... I need a book that will break it down simply so I can begin to understand how write code.
Thanks alot