question

LauraGomez-5582 avatar image
0 Votes"
LauraGomez-5582 asked ·

Error when appending Excel files in Access

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

not-supported
10 |1000 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

LeonLaude avatar image
0 Votes"
LeonLaude answered ·

Hi,

Q&A currently supports the products listed over here https://docs.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


·
10 |1000 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

LauraGomez-5582 avatar image
0 Votes"
LauraGomez-5582 answered ·

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

· 1 ·
10 |1000 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

You're welcome.

0 Votes 0 ·