I have no real idea what an import/export specification is and why they are necessary.
I have a query that I run against 1 database and in the vba I export a csv which in turn is used to update a table in a second database. The 2 database are identical as far as the design is concerned and only the data may be different.
When I tried to import the data via vba I then came across the import/export specification through an error I received. I noted if I used the wizard I could import without a problem but in the VBA it was crashing because I didn't have one of the aforementioned beasts. Somewhere on this site I found out how to create one using the import wizard and going into the advanced option and saving it. Now I can set this up in the first instance but if the tables change I presume the import/export specification file must change too. So! Can I create this specification file within vba when I create my export file. I presume I would have to delete the old one a create the new but how do I do that?
Any help appreciated because I don't understand what I've researched thus far!
I have a query that I run against 1 database and in the vba I export a csv which in turn is used to update a table in a second database. The 2 database are identical as far as the design is concerned and only the data may be different.
When I tried to import the data via vba I then came across the import/export specification through an error I received. I noted if I used the wizard I could import without a problem but in the VBA it was crashing because I didn't have one of the aforementioned beasts. Somewhere on this site I found out how to create one using the import wizard and going into the advanced option and saving it. Now I can set this up in the first instance but if the tables change I presume the import/export specification file must change too. So! Can I create this specification file within vba when I create my export file. I presume I would have to delete the old one a create the new but how do I do that?
Any help appreciated because I don't understand what I've researched thus far!