Import (not link) CSV file into MS Access without automation (schema.ini)
Posted on 2002-07-02
Have been linking csv files into Microsoft Access using a schema.ini file. Now, I have discovered that if I link a second file in using a different schema.ini file the first linked file is no longer linked correctly. For example, if the second schema has less fields some of the fields for the first link will not show up.
So now I want to import a csv file using the same information I have in the schema file. Seems like there should be a way to do this. Access has a "TransferDatabase" command using a "Specification" which seems to be an internal version of the schema file.
Have not been able to find out how to do this.
Note: I know that automation could be used, but I am also having a problem with that ("429 - ActiveX cannot create object excel"). So using automation can not be an answer to this question.