Search results

Thanks guys

Thanks chaps That seems to have fixed it. Simon

Ideally I would like to have both text and number values imported to the field. Hmmm. I'll keep on thinking. Thanks Simon

Hi Uncle Gizmo It does sound like the same type of problem. Were you able to fix it or get round it? Cheers SImon

Hi There I'm an intermediate Access user trying to import a large CSV file to a Table using the macro "transfer spreadsheet" function. The csv has about 50 fields - all are imported OK except for one ID field. The offending csv field contains numbers (eg "123456") and text (eg "none" or...