The problem
The problem is I don't think any of these examples (which are only a handful that apply to importing) have the necessary code I can use to decipher what I need to use in my import sub command. I feel I'm getting pretty close, but like when it comes to field names, how do I import when the field names in my access database don't exactly match up with the field names in the .csv file I'm trying to import. I tried running a particular file, so I wrote out the exact filename I was importing. I got a run-time error stating that the field name in my .csv file is unrecognized. I'm assuming I have to somehow define the field names in the import command. Would I need to type out every field name in some form or fashion and if so, then how do I go about doing this? If so, how do I make it to where my field names in my .csv file will automatically import in the correct fields in my access table? For instance, my .csv file has the field name "PRO #". In my table, however, the field name for this is "K95_PRONUM". How do I match these up to where it will place the right data in the right fields (even though the similar field names are titled differently)?