Let me give you the back story....
There were 30 (I think, maybe more) .csv files, that I compiled into one .csv file and created a database with and have multiple queries, and a form built custom to what I am needing.
The problem, I found out about an hour ago, there are 2 more .csv files that are needing to be added to this database. I know when I was in the creation stages, that I was unable to add .csv1 as a Table, and then append .csv2 to the same Table. I think it is buggy programs at work that prevented it, but that is another story.
I know that with the same DOS command I can combine these two .csv files into one .csv file, but my question is. How can I get all of the data onto one table? I am fine with having a Table1 and a Table2 as long as I am able to have a MasterTable that has both of these Tables combined.