Hi,
I'm running an Append Query from an Excel <linked> file to a table in access. From what I can tell, the first filed is overflowing with a linked filed numeric of 'Double'. You can't change linked table fields. However when I first link the Excel file, the Append works... :D only when I reboot the PC and start the next day's work, do I get this message... :eek:

1. Should I include in my MACRO an import to a table and then append...? :mad:
2. Is there a trick in the append query I can use to prevent the error...? :rolleyes:

Thanks
MD

I Must be sure that the field in my Excel File is set to Number... no Decimals.

Sorry for this post, but looking up topics here was a lesson about this Forum!

Good job Guys and Gals!!!

:D :D :D :D :D :D :D :D