I am using A2007 with W7. I import a csv file that is downloaded into a table from a website. No problem until recently when they changed the order of columns. This caused data to be imported into the wrong fields. Example, zip code ended in the Last Name field. Apparently, the order of column names matters and gets printed in stone somehow.
I tried deleting the existing table before running the import code so that the old table wouldn't influence the procedure, but still happens. Here is basic code that I used.
DoCmd.DeleteObject acTable, "tableName"
DoCmd.TransferText acImportDelim, "Spec Name", "tableName", myPath & csvfilName, True, "" '
Is there a way to not be dependent on column order or is there something wrong with my Access? Any help much appreciated. I really need a way not to be dependent on column order. Driving me nuts.