Error when appending Excel files in Access

Question

Hello comunity!

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!

Cheers,

Laura

Answer 1

Hi,

Q&A currently supports the products listed over here https://learn.microsoft.com/en-us/answers/products (more to be added later on).

You can reach the experts in the dedicated forums over here:

Microsoft Excel
https://social.technet.microsoft.com/Forums/en-us/home?forum=excel

Microsoft Access
https://social.msdn.microsoft.com/Forums/office/en-US/home?forum=accessdev

(Please don't forget to mark helpful replies as answer)

Best regards,
Leon

Answer 2

oh thank you for your quick reply! I will try there :)