merlynsdad
Programmer
I need to import a csv file into a new Access 2003 table using VBA. The file I'm given has 24 fields, but I only need 8 of them, and if I could change their field names that would be nice.
brings in all 24 fields. Is there a way to only bring in the ones I want, or is it better to bring in the whole file and then delete the fields I don't want?
If the square peg won't fit in the round hole, sand off the corners.
Code:
DoCmd.TransferText acImportDelim, , "tblTestCSV2", "S:\WI\ACS\ACS QA\weektest.csv", True, ""
brings in all 24 fields. Is there a way to only bring in the ones I want, or is it better to bring in the whole file and then delete the fields I don't want?
If the square peg won't fit in the round hole, sand off the corners.