Hi Guys
I have an issue that has arose in my database.My database has three main tables file 1 file 2 and file 1&2 joint.
The data for these tables is uploaded daily by two macro enabled excel sheets. both macros are exactly the same but for some reason the file 2 upload will not upload anything but numbers although it was originally formatted as text. It does not happen in file one .Ive checked the formatting in the tables and for some reason table two field keeps changing??? anyone have any ideas?