Neil Try higlighting data and headers only and past into a new sheet, then import the new sheet ...... you may have a field other than your data that is being imported and is corrupting import
Cheers John At 04:52 PM 5/04/2009, you wrote: >I am struggling to import a three column list of data,less than 100 >records from Excel into a three field table in Access. I'm sure I've >done this in the past. I've tried saving the Excel file as Delimited >text and CSV format but Acess still claims something like 'record >too long'or somesuch. > >Can anyone offer some suggestions for this process? > >Thanks. > >Neil Ives > > [Non-text portions of this message have been removed]
