When linking to a file in excel (data downloaded form our mainframe), and all fields formatted "General", all data is visible in Access unless we manually add a new record to the Excel file.
In one of the fields, which is numeric-looking, like 324563, it comes across into Access as #Num and all the other records (from mainframe) look like they are supposed to look.
Tried clearing all Excel formatting and resetting to General format, nada. Clearing all, resetting to text format, nada.
I'm on Excel and Acess 2003.