Hi,
I have successfully create a front end with a button to import an excel spreadsheet, the data contains a lot of fields (a mixture of short text and numeric values).
I am currently getting import errors that are simply because access is assuming the data type "double" is valid for some fields when in fact short text is required. how do i get access to switch each field data type to short text?
any help would be greatly appreciated.
Many thanks.