I am just trying to append some excel files in Access for first time.... what is the problem?
When i import the first table... the first column has a title; in the title ex: (Field1.)
When importing the data that . disappears and i am left with (Field1). The next ones that come later still contain (Field1). so at the end (Field1) doesnt match (Field1.) and it creates an error.
Any idea on how could i solve this without changing all the titles from the other files? I have around 500!