I am currently experiencing an error I can not determine.
I have weekly files of data, each file has the exact same headings, these files are excel files.
If I import file 1 into table 1, then import file 2 into table 1 I get an error, the error simply says an error occurred the file was not imported. So my assumption would be the headings are not the same. However they are, 100%. If I import both files to separate tables and then use a union query then its not a problem. However, at the moment I am trying to analyze a few months data, while I could probably import them all, that's a huge union query to work on, when having one table would be simpler.
I am racking my brain trying to think of a reason they wont import, maybe when importing a field is a number, but if the first cell is blank then maybe it thinks I'm trying to import a text into a number field? SO then the only solution is to make the first table all text fields import all the tables and then change them back, but then next week when I want to add another weeks data I would have to do the same, that's assuming that's the error.
Any ideas?
I have weekly files of data, each file has the exact same headings, these files are excel files.
If I import file 1 into table 1, then import file 2 into table 1 I get an error, the error simply says an error occurred the file was not imported. So my assumption would be the headings are not the same. However they are, 100%. If I import both files to separate tables and then use a union query then its not a problem. However, at the moment I am trying to analyze a few months data, while I could probably import them all, that's a huge union query to work on, when having one table would be simpler.
I am racking my brain trying to think of a reason they wont import, maybe when importing a field is a number, but if the first cell is blank then maybe it thinks I'm trying to import a text into a number field? SO then the only solution is to make the first table all text fields import all the tables and then change them back, but then next week when I want to add another weeks data I would have to do the same, that's assuming that's the error.
Any ideas?