NUMERIC FIELD OVERFLOW!!! <Gah!!>

[Maddd0ggg]

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... only when I reboot the PC and start the next day's work, do I get this message...

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

Thanks
MD

 

[Maddd0ggg]

Found My Own Answer

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!!!